As many other people I am stugglin with a file that need to have a one digit number in column 1 row 1
name1 : name 2 : name 3
Number 2 tells the program which this file is going to be imported to which place this data should be saved on.
Is there a way to solve this in any way?
I was thinking of adding another tfileinputdelimited with just the number 2 in it, is this possible?
Solved! Go to Solution.
You need to access the file twice:
- 1rst time with no header and limit set to 1 to get just the 1rst record and save its value somewhere (a global variable for example).
- 2nd time with header set to 1 to get the file content except the header line and then you go with the rest of the job
Came up with this solution in my tFileOutput which adds the number I want, the drawback is that it adds it on every row.
What should I write in the Var expression field to make it stop after first row? Please find attached files
"2\n" + row1.ISIN
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema