Hello
I'm using file pattern in sequential file stage but facing issue with column names.
File1
Name,Job
abc,Manager
File2
Name,Job
zyx,President
I'm getting out put as
abc,Manager
Name,Job
zyx,President
I have picked first line is column name as true. How to skip the column names from other files?.
Thanks
File Pattern in Sequential Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As soon as you choose File Pattern as the read mode, First Line is Column Names property becomes invalidated. You even get an advisory message box telling you that this is the case. On that basis I don't believe you can call it a bug. Add a reject link to the Sequential File stage to capture the header lines (which will presumably not comply with the record schema of the detail lines).
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.