Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Prasanna3
Contributor
Contributor

Scenario based Question in Talend???

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.
Labels (3)
35 Replies
Ganshyam
Creator II
Creator II

Hello,

 

Change the condition in tmap 

0683p000009Lzwm.png

 

0683p000009M06C.png

 

Hope this solves your purpose..!!!

Regards

Ganshyam

Prasanna3
Contributor
Contributor
Author

I am not getting result.i was just defind columns in output.

What the header value should I give in tfileinpitdelimited
Prasanna3
Contributor
Contributor
Author

It's working perfectly.
Can you please explain how its working.
And what Boolean context header will do
Ganshyam
Creator II
Creator II

Hello,

 

Initially We are setting the value for header as false in context variable.

In tjavarow if condition checks the character if it matches then context variable header is set to true and the same context variable is used in tmap to read the data starting from header value.

 

Hope this clears your doubts..!!

 

Regards

Ganshyam

Prasanna3
Contributor
Contributor
Author

What is the meaning of setting context header to true.

What actually that will do
Prasanna3
Contributor
Contributor
Author

Thanks for your solution.

With the same scenario if I want to process multiple files then how?
Prasanna3
Contributor
Contributor
Author

With the same scenario .
If I want to process multiple Files how to do that?
Ganshyam
Creator II
Creator II

Hello,

 

 

Need to give it  a try..

Meanwhile you can use try using tjava component to write the java code to handle multiple file..

As the existing flow will read only first file and the other files record be as it is...

 

Regards

Ganshyam

Prasanna3
Contributor
Contributor
Author

Can you please tell me how to write Java code to handle multiple files
Ganshyam
Creator II
Creator II

Hello,

 

Please post your exact requirement with screenshot for mutiple file and expected output.

 

Regards

Ganshyam