Skip to Content

Help required on SAP Dataservices Pivot Transformation

Mar 16, 2017 at 05:11 AM


avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

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 :


Soumyadeb Halder

total-job.jpg (79.6 kB)
query.jpg (70.8 kB)
pivot.jpg (69.0 kB)
query-1.jpg (66.1 kB)
query-2.jpg (63.3 kB)
query-3.jpg (61.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks a ton Soumyadeb. Thats a perfect solution