Hi,
I am trying to read multiple file of same layout and similar file name using File Pattern of Sequential file stage.
All the files has file header , I defined First Line has header in Seq file Stage, but it is considering header of only 1 file , for all other files , it is still reading header as first record.
Is there a way , where it skips header of all the files
Thank you in Advance.
Multiple file reading using file pattern
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Hi,
I guess you can do it that way :
-activate both ouput filename in one column & row number in one column output
-hash on filename&sort on filename&row number in a transformer, then use variable logic to get rid of the first line, like below
Let us know if it works
Eric
I guess you can do it that way :
-activate both ouput filename in one column & row number in one column output
-hash on filename&sort on filename&row number in a transformer, then use variable logic to get rid of the first line, like below
Code: Select all
svIN=filename
svTestFirstLine=if svIN<>svOLDIN then 1 else 0
svOLDIN=filename
Eric
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India
Version 11.3 processes a file pattern in parallel by default.
Choose a job you love, and you will never have to work a day in your life. - Confucius