Help required on SAP Dataservices Pivot Transformation

[former_member188392]

Please advise how can I transpose the below data

Sample file is attached.pivot-v1.txt

[Former Member · Accepted solution]

Hi Thomas,

Please check the screenshots attached. These are from the JOB that i created to implemented your requirement.

Hope this will answer your question.

Job Screenshot:

Query Screenshot:

Pivot Screenshot:

Query_1 Screenshot:

Query_2 Screenshot:

Query_3 Screenshot:

Query_4_From_Clause Screenshot :

Query_4_OrderBy_Clause Screenshot :

Thanks

Soumyadeb Halder

[former_member188392 · Accepted solution]

Thanks a ton Soumyadeb. Thats a perfect solution