How to achieve this?

My input data:
Field_Name Value
Customer_ID 100
Customer_Name ABC
Customer_City Delhi
Customer_ID 200
Customer_Name BCD
Customer_City Mumbai
My output should look like
Customer_ID Customer_Name Customer_City
100 ABC Delhi
200 BCD Mumbai
  • Interview Candidate
  • 8
  • 4940

Showing Answers 1 - 8 of 8 Answers

raghu

  • Feb 4th, 2016
 

You can use pivot enterprise stage to achieve this. Select vertical option in that stage.

  Was this answer useful?  Yes

sudheer

  • Feb 24th, 2016
 

Use Transformer with stg = If Trim(FIELD_NAME)<>Customer_ID Then stg Else stg+1 (default 0)
Populate this stg into new column say "UNIQID"
Use vertical Pivot, options as Groupby on UNIQID and Pivot on VALUE with array size of 3, then map values correspondingly.

  Was this answer useful?  Yes

Ram

  • Mar 10th, 2016
 

Its simple..
Src(file 2 cols) --> Transform (drop 1st col and create dummy field for group id) -->
Pivot enterprise(type vertical and array size=3) --> copy (rename the column names as required) --> trg.
Pls try , it will work..thanks !

  Was this answer useful?  Yes

Arpit jain

  • Apr 5th, 2016
 

We can do this by using roll up component by using accumulation function in it .

  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