topic Re: Scenario based Question in Talend??? in Talend Studio

Scenario based Question in Talend???

Prasanna3 — Sat, 16 Nov 2024 07:34:45 GMT

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.

Re: Scenario based Question in Talend???

TRF — Wed, 26 Sep 2018 11:19:29 GMT

What do you mean?

Re: Scenario based Question in Talend???

Prasanna3 — Wed, 26 Sep 2018 11:21:34 GMT

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

For example header is in middle of the CSV file

Re: Scenario based Question in Talend???

Anonymous — Wed, 26 Sep 2018 13:22:16 GMT

you can read the file like the above

Re: Scenario based Question in Talend???

Prasanna3 — Wed, 26 Sep 2018 13:24:43 GMT

No my question is

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

Re: Scenario based Question in Talend???

Anonymous — Wed, 26 Sep 2018 13:26:29 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Wed, 26 Sep 2018 13:36:20 GMT

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

Re: Scenario based Question in Talend???

Ganshyam — Wed, 26 Sep 2018 15:31:55 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Wed, 26 Sep 2018 15:47:29 GMT

How we can find position of header in CSV file

Re: Scenario based Question in Talend???

Ganshyam — Thu, 27 Sep 2018 10:13:30 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Thu, 27 Sep 2018 10:43:39 GMT

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

Re: Scenario based Question in Talend???

Ganshyam — Thu, 27 Sep 2018 11:37:59 GMT

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

Re: Scenario based Question in Talend???

Anonymous — Thu, 27 Sep 2018 13:47:56 GMT

Can you please elaborate the scenario

Re: Scenario based Question in Talend???

Anonymous — Thu, 27 Sep 2018 13:51:22 GMT

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

Re: Scenario based Question in Talend???

Ganshyam — Thu, 27 Sep 2018 14:02:26 GMT

Hello,

Hope this helps..!!!

Regards

Ganshyam

Re: Scenario based Question in Talend???

Anonymous — Thu, 27 Sep 2018 15:01:02 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Thu, 27 Sep 2018 15:15:56 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Fri, 28 Sep 2018 04:20:32 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Fri, 28 Sep 2018 04:23:53 GMT

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

Re: Scenario based Question in Talend???

Ganshyam — Fri, 28 Sep 2018 08:41:08 GMT

Hello,

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

Regards

Ganshyam