Hi
I have a file which has information spiltted into 3 parts.
1. Header
2. Details
3. Trailer
Below is the sample data which i have to load.
97 DSS5320 010209
0169000104584400407079670460000012807550000000000 844
0169000237584400361566050460000002044570000000000 844
0169000238584400361566050460000041927810000000000 844
0169000239584400361566050460000041927810000000000 844
0169000240584400362061660460000001010000000000000 844
0169000241584400362061660460000001010000000000000 844
0169000242584400362061660460000004010000000000000 844
98 000001 00000000000000000000
First line data - starting with 97 is header data
Last line data - starting with 98 is trailer data
Rest of the data is detail data.
Can you please help me in uploading the above data which is coming in file. Please let me know if this can be done thru a single stage.If so, which stage can i use?Else let me know the alternative methods of doing it.Thanks in advance.
Regards,
Pavan
File upload
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Another method is to use a Sequential File stage to read each line as a single VarChar field then a Column Import stage or a Transformer stage to parse the different record types.
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.