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