to remove first line from mutiple files

developeretl · Post by **developeretl** » Thu Aug 04, 2011 1:18 pm

Franklin,
I should exclude the first line of the files. If I keep it true it will consider first line as column . In target I need to populate to target with columns name excluding the first line from source

chulett · Post by **chulett** » Thu Aug 04, 2011 1:26 pm

No, setting that option to true will cause the first record in the file to be skipped over.

FranklinE · Post by **FranklinE** » Thu Aug 04, 2011 2:36 pm

Remember: I'm using 7x, not 8x, so if 8x is different I'll be wrong... That said, may I state the obvious?

The sequential file stage(s) that read(s) the file(s) will simply ignore (as in not pass through the output link) the first record. It doesn't matter what's in that record. The attribute in this case has a misleading name.

The sequential file stage that writes a file can have different attributes.

chulett · Post by **chulett** » Thu Aug 04, 2011 3:05 pm

FranklinE wrote:Remember: I'm using 7x, not 8x, so if 8x is different I'll be wrong...

It's not... nor are you.

chulett · Post by **chulett** » Fri Aug 05, 2011 7:33 am

Did you get this working?

It has been bugging me, I finally got a chance to dig thru the 8.5 docs and see how it was explained. Turns out... poorly.

For an Output (reading) link:

First Line is Column Names

Specifies that the first line of the file contains column names. This property is false by default.

For an Input (writing) link:

First Line is Column Names

Specifies that the first line of the file contains column names. This property is false by default.

Gee, that's helpful and really highlights the difference between the two.

Still surprised it's just a boolean value, Informatica has a "Records to skip" option that I can set to 0, 1 or any other appropriate number... just had a file with two header records, no automatic way to handle that in DataStage.

developeretl · Post by **developeretl** » Fri Aug 05, 2011 8:02 am

I have tried that option " First line is column names " . It did not work . Will try to use the row number logic to exclude the first row in transformer.

chulett · Post by **chulett** » Fri Aug 05, 2011 8:42 am

Tell us what "did not work" about it as it certainly should have as that's exactly what it is for.

developeretl · Post by **developeretl** » Thu Aug 11, 2011 12:39 pm

I was getting import error for the columns. So we have removed the first line using shell scripts. Thanks for the information

imfarhan · Post by **imfarhan** » Mon Sep 29, 2014 4:25 am

Select the first line as Header and then

Under "Format" tab
I've done the settings as follows:
Final delimiter = end
Recod Delimiter = newline
Field defaults:
Delimeter = comma
Quote = Double