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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mapping .txt in talend

I need to map the first 2 rows from a .txt file into a database in talend. Right now mapping csv files work, however since I don't have headers in the .txt file how can I map it.
Lets say my txt file has data as follows: 
apple 
banana 
23321
32132321
3212
I want to take apple and banana (rows 1 and 2 ) each time and map them to the table in db. This should also be automatic, thats why im currently using filewatcher.
The image shows what I did so far 0683p000009M2iO.png
Labels (3)
1 Reply
akumar2301
Specialist II
Specialist II

Will your database table change for each iteration?

If no, just use Limit as 2 and header 0.
Schema should be same as table is same.