Generate multiple records from 1 record in the input based o
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Parse the comma-delimited values into separate fields (using a Transformer or Column Import stage) then use a Pivot stage to generate the rows with the first four fields defined as the Pivot Keys.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Generate multiple records from 1 record in the input bas
Since it looks like you're using Transformation eXtender (not Datastage), you'll need to create a group in your output that corresponds to your group in your input. (the input group being within the record, your output group being a "virtual" group of records). Also - make sure that your input group (which is field5) is defined as one field that occurs multiple times. Then pass the input record plus one member of the input group to the output group.