Reverse Pivoting

I have two columns of data
My input data
Field Name Value
Customer_ID 100
Customer_Name ABC
Customer_City Kolkata
Customer_ID 200
Customer_Name BCD
CUstomer_City Mumbai
Customer_ID 300
Customer_Name CDE
Customer_City Delhi
Output date should be
Customer_ID Customer_Name Customer_City
100 ABC Kolkata
200 BCD Mumbai
300 CDE Delhi
How to achieve this?

Questions by Sreemoyee Chakraborty

Showing Answers 1 - 1 of 1 Answers

Pavan Kumar

  • Sep 17th, 2015

You can use pivot enterprise stage to achieve the desired output.
Source >> Pivot Enterprise >> Destination. In Pivot set array size as three to spit the data into three records. Note that you are doing vertical pivot here not horizontal.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions