Splitting one input record into multiple output records
Posted: Mon Aug 11, 2003 6:20 pm
I have an input record with the format:
(a, b ,c ,d ,tax1, value1 ,anothervalue1, tax2, value2, anothervalue2)
Datatype of tax1 and tax2 is tax, value1 and value2 is value, anothervalue1 and anothervalue2 is anothervalue.
My output record looks like:
(tax, value, anothervalue) - So output record is a subset of the input record.
How can I use the transformer to create 2 output records:
tax1, value1, anothervalue1
tax2 ,value2 a,nothervalue2
The problem I am having is that I am not able to map both (tax1,value1,anothervalue1) and (tax2,value2,anothervalue2) from the input file to the output file (tax,value,anothervalue).
So basically from a 1 record input file I need 2 records in the output file and all the fields in both output records are in the single record of the input file.
Any suggestions would be helpful.
Regards.
(a, b ,c ,d ,tax1, value1 ,anothervalue1, tax2, value2, anothervalue2)
Datatype of tax1 and tax2 is tax, value1 and value2 is value, anothervalue1 and anothervalue2 is anothervalue.
My output record looks like:
(tax, value, anothervalue) - So output record is a subset of the input record.
How can I use the transformer to create 2 output records:
tax1, value1, anothervalue1
tax2 ,value2 a,nothervalue2
The problem I am having is that I am not able to map both (tax1,value1,anothervalue1) and (tax2,value2,anothervalue2) from the input file to the output file (tax,value,anothervalue).
So basically from a 1 record input file I need 2 records in the output file and all the fields in both output records are in the single record of the input file.
Any suggestions would be helpful.
Regards.