topic Number in header in Talend Studio

Number in header

Anonymous — Sat, 16 Nov 2024 04:50:07 GMT

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?

TRF — Thu, 29 Aug 2019 08:10:48 GMT

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

Anonymous — Thu, 29 Aug 2019 08:29:26 GMT

Many thanks TRF for fast reply, will test and revert back

Anonymous — Thu, 29 Aug 2019 10:13:01 GMT

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

TRF — Thu, 29 Aug 2019 10:25:07 GMT

Try this in your tMap (not tested):

Then reuse Var.var2 to populate your output field.

Anonymous — Thu, 29 Aug 2019 11:57:43 GMT

Problem solved! Many thanks TRF, some minor adjustments made and the thing worked!