DSXchange

Data is in source as below and needed to be loaded into target as specified.
I thought of pivot stage. Couldyou asuugest any ideas?

Source:
=======
ORDER ID GROUND AIR EXPRESS PRIORTY
1 None No No Yes
2 Yes None No Yes

Target:
======
ORDER ID Ship Desc
1 GROUND None
1 AIR No
1 EXPRESS No
1 PRIORTY Yes
2 GROUND Yes
2 AIR None
2 EXPRESS No
2 PRIORTY Yes

Thank you

Transformer stage with four outputs brought together in a downstream Funnel stage.

Thank you Ray.
ORDER_ID GROUND AIR EXPRESS PRIORTY
1 None No No Yes
2 Yes None No Yes

When I run the job, data displays as

ORDER ID GROUND AIR EXPRESS PRIORTY
1 None No No Yes
1 None No No Yes
1 None No No Yes
1 None No No Yes
2 Yes None No Yes
2 Yes None No Yes
2 Yes None No Yes
2 Yes None No Yes

It should be
ORDER ID
1 Ground NONE
1 Air No
1 Express No
1 Priority Yes
Transformet has 4 outputs fed to Funnel. I used 'Continuous Funnel',.

-Thank you

Each output link from the Transformer has three columns. The first is mapped directly from the ORDER_ID column. The second is derived - differently on each link - as a constant, one of the four remaining column headings, perhaps with case adjusted (GROUND --> "Ground"). The third is mapped directly from the appropriate non-key input column.

double post deleted.

take a look at this, which answers your question well.

Pivoting with an description
viewtopic.php?t=142442