Extract multiple excel files with tfileList

[SR2210]

Hi All,

I have 2 excel files with different names;

1. *** Manufacturing POP. xlsx
2. 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

[pakapi_]

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 ?

[SR2210]

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

[Ganshyam · Accepted solution]

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

[SR2210]

Thanks!