Example use of the pivot stage

I couldn't find an example of the Datastage pivot stage and it's not very obvious how to use it. Thats why i've created this page. It shows an example of how you use it.

Input link

The input link has 11 columns. One for the jobname and 10 for used functions.

Output link

The output link has two columns. The jobname and one for the function names. Per input row, there are 10 rows outputted. Even if the fields are NULL. Divide the fieldnames with spaces, not with any other delimiter.