How to denormalize data data from rows to columns?

[brauliolam]

Hi,

I would like to know how I can denormalize data from rows to columns. For example:

I have the following results set from the DB:

FirstName,MemberID,OrderID,ProductIDs,ProductNames
John,1234,55555,98765,iPhone 5 White
John,1234,55555,45678,Recharge Cable

I would like to output a CSV like this - note the pipe (|) symbol between records in the last two columns:
FirstName,MemberID,OrderID,ProductIDs,ProductNames
John,1234,55555,98765|45678,iPhone 5 White|Recharge Cable

Thanks,

Braulio

[imriskal]

Hello, Braulio,

Your task seems like the right place for Denormalizer component. Please, see the example graph in attachment.

Best regards,

• denormalizer.grf
• denorm_input.csv