How to denormalize data data from rows to columns?

brauliolam

• May 21, 2013 00:00

• Answered

Follow

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

  • May 22, 2013 10:52

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.