DSXchange

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

I would think that should happen automatically, i.e. that it should skip the first record of each file, not just the first file. Smells like a bug to me.

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).

Ah... would have been nice to know about the advisory message box. So, no bug but rather 'Working As Designed' as they say.