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
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
-
Hello, Braulio,
Your task seems like the right place for Denormalizer component. Please, see the example graph in attachment.
Best regards,
Please sign in to leave a comment.
Comments 1