Skip to Content

Help required on SAP Dataservices Pivot Transformation

Please advise how can I transpose the below data

Sample file is attached.pivot-v1.txt

pivot.jpg (60.5 kB)
pivot-v1.txt (150 B)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 16, 2017 at 08:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded