Page 1 of 1
Posted: Thu Mar 11, 2010 3:56 am
by ray.wurlod
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.
Re: Generate multiple records from 1 record in the input bas
Posted: Thu Mar 18, 2010 12:32 am
by smeliot
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.