topic Re: Extract multiple excel files with tfileList in Talend Studio

Extract multiple excel files with tfileList

SR2210 — Sat, 16 Nov 2024 01:21:58 GMT

Hi All,

I have 2 excel files with different names;

*** Manufacturing POP. xlsx
PC ***.xlsx

I need to load both into PostgreSQL database. The problem is, only the first tfileinputExcel is picking up the 2 files. The second tfileinputExcel is extracting data from the first file only. As you can see in screenshot below, the first tfileinputExcel loads 395 rows and the second one loads only 346 rows. Can anyone help on this? Screenshot of my job is as below. Thank you

Re: Extract multiple excel files with tfileList

pakapi_ — Tue, 29 Sep 2020 18:27:13 GMT

I don't know what is going on in tMap's, but I think, you should use another tFileList, to load the second file - it will be more redable. What do you think ?

Re: Extract multiple excel files with tfileList

SR2210 — Wed, 30 Sep 2020 06:05:18 GMT

to use another tFileList should work, but since the structure of the files (sheet name, columns) are exactly the same, I just wonder if it's possible to list all the file names that I require in the filemask section and tFileInputExcel would be able to pick all of them in one go

Re: Extract multiple excel files with tfileList

Ganshyam — Wed, 30 Sep 2020 09:42:43 GMT

Hi,

Iterating through the tfilelist might solve the purpose.It will pick up all the files that matches the file mask. Here you can also set the order for iteration.

Regards

Re: Extract multiple excel files with tfileList

SR2210 — Sat, 24 Oct 2020 10:06:28 GMT

Thanks!