DSXchange

Hi All,

Is there any way to remove the header from the file . Where I am using file type as file pattern.

Bascially I am reading multiple files.

Please hel me on this.

Thanks & Regards,
Kumar66

Since you are using file pattern option , i think filter option wont be available in seq file stage .So , we can remove the headers with the help of transformer constraints

You can use filter stage after reading the data from multiple files to drop the rows which is the header of the file.

Under "options" in the sequential file stage you can specify "First line is Column Names" which effectively skips the first line.

Not with a file pattern and multiple files, unfortunately.

Craig - I just had to run to a designer client and try that out, but now I know that you are correct.

Yah, would be cool if it worked and would certainly simplify things.

Maybe you can filter them out in a stage or do 'grep -v' for something special in header.

Just had a look for myself, I still have the "First Line is Column Names" option when selecting File Pattern, haven't run it but why can't it be used?

Or stream in as single column and do a DCount - assuming header record has different number of columns as other rows - then send through a column import.

Oh, you can certainly use it, it's just that it won't work on anything other than the first file from what I recall.

Ahhh, I see... so pretty pointless then...