How to splite Header from the file

[ravindrag]

Hi all,

i have to splite Header from the file and this Header i have to send onther file

Thanx inadance

[gateleys]

Assuming the header is the first row in the file, use a transformer with 2 output links. To get rows minus the header, use the constraint @INROWNUM > 1, and to get only the header row, use @INROWNUM = 1.

gateleys

[DeepakCorning]

Or if you have a header format such as HDRdatetimeatmp then set a flag saying if input such as HDR then set the flag "Y" or "N" and pass the rows respectively.

The above solution is perfect but I had situations where the "headers" where every where in the file

[kris007]

Can you mention what is the problem you are facing when trying to do what gateleys has suggested? Is your input file a fixedwidth file? Also, since you need to send the header data to a seperate file, all would need do it is to map three columns in question to three columns onto the file in the Transformer Stage or concatenate those three columns into a single column based upon your requirement.

[Kirtikumar]

If your file has different format of the header and other records i.e. metadata for header and other records - then you might have to use a bit diff approach.

In this case, you can read the whole line in a single varchar column and then as suggested separate out header and other records based on INROWNUM. Then after this you can use row splitter to split multiple cols from single col.

[ravindrag]

Ae go re go

[kris007]

What does that mean

[DeepakCorning]

Hmmm sounds like a different Language to me :D