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.

[Prasanna3]

Can you please tell me what the number you given in Header filed in tfileinpitdelimited

[Ganshyam]

Hello,

I did not specify any number for header,

1) Took one context variable with default values as false.

2) In tjavarow 

   if (input_row.empno.equalsIgnoreCase("empno"))  context.header = true;

3) In tmap : -  !row2.empno.equalsIgnoreCase("empno") && (boolean) context.header

Regards

Ganshyam

[Anonymous]

Can you please elaborate the scenario

[Anonymous]

Can you please elaborate the code that you wrote in tjavarow component

[Ganshyam]

Hello,

Hope this helps..!!!

Regards

Ganshyam

[Anonymous]

Thank you for the response it's worked for me,But im not understanding the code that you wrote can you please explain.

[Prasanna3]

I have one more doubt.
How can I write below command in tsystem
For /f "delims=:" %%a in ('findstr /n "cid" "filepath"')

[Prasanna3]

As you mentioned on which component we should take context variable default as false .
Where we use this context variable.can you please elaborate explanation

[Prasanna3]

And also I want to read header also but in your output there is no header

[Ganshyam]

Hello,

Define the context variable header under context tab in job design.

Regards

Ganshyam