informix-datastage@oliver.com
Posted: Tue Apr 24, 2001 12:18 pm
Greetings,
I need to read a sequential file extract from a data system. The file contains several lines of indented heirarchy before reaching the one or more true data lines. When I hit a data line, I need to create an output record with the comma delimited data from the data line plus all of the previous heirarchy data. An example
1234567 >
Department line
abcde > Cost
center line
building2 >
Location line
Bob,10,20,30,40,.... > Data line
Output line
1234567,abcde,building2,Bob,10,20,30,40,...
I tried to use stage variables, but they seem to reset prior to getting to the data line. Any help would be appreciated. By the way, Im using DS 4.0 on a Sun/Solaris server. Thanks, Bob
I need to read a sequential file extract from a data system. The file contains several lines of indented heirarchy before reaching the one or more true data lines. When I hit a data line, I need to create an output record with the comma delimited data from the data line plus all of the previous heirarchy data. An example
1234567 >
Department line
abcde > Cost
center line
building2 >
Location line
Bob,10,20,30,40,.... > Data line
Output line
1234567,abcde,building2,Bob,10,20,30,40,...
I tried to use stage variables, but they seem to reset prior to getting to the data line. Any help would be appreciated. By the way, Im using DS 4.0 on a Sun/Solaris server. Thanks, Bob