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 ...

Pavan Kumar

• Sep 18th, 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.

Answer Question  Select Best Answer