File Pattern in Sequential Stage

shiva459 · Post by **shiva459** » Sat Jun 21, 2008 12:22 pm

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

chulett · Post by **chulett** » Sat Jun 21, 2008 2:38 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 21, 2008 4:31 pm

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

chulett · Post by **chulett** » Sat Jun 21, 2008 6:46 pm

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