AnsweredAssumed Answered

File Morphing

Question asked by abhisheksharma390278 on Sep 1, 2016
Latest reply on Sep 6, 2016 by Seth Duda

Hello Everyone,

 

I am trying to morph a flat file profile into another but no luck yet. Below are the details, please share your thoughts.

 

I am reading a csv file from SFTP with below columns:

EmpID         Role                  Name

1001         TestRole1               Jeff

1001         TestRole2               Jeff

1001         TestRole3               Jeff

1001         TestRole1               Jeff

1001         TestRole4               Jeff

 

I need to merge all 5 rows into one as below:

EmpID         Role1            Role2               Role3            Role4            Role5            Name

1001         TestRole1      TestRole2      TestRole3      TestRole1      TestRole4            Jeff

Outcomes