Scenario based Question in Talend???

[Prasanna3]

I have CSV file like below

123 145 167
345 567 789


empno ename sal
111 Kiran 200
112. King 300

how to read CSV file from starting header.

[TRF]

What do you mean?

[Prasanna3]

I want to read CSV file from where header is started.

For example header is in middle of the CSV file

[Anonymous]

you can read the file like the above

[Prasanna3]

No my question is

Header is available in middle of the CSV file I want to read it from there

[Anonymous]

If you specify header as 3 in your scenario you can get the values after the header.

[Prasanna3]

I don't know how many lines available before header then that time how we will do that?

[Ganshyam]

Hello,

You are not sure about from where the header line will start, probably it could be any number may be 4,5 ..??

Regards

Ganshyam

[Prasanna3]

How we can find position of header in CSV file

[Ganshyam]

Hello,

Below is the data in the csv file where we are not sure about the starting of the header.

Job Design.

Hope this is the required solution.

Regards

Ganshyam