topic Re: Reading multiple excel files using tFileList and display the name of files in Talend Studio

Reading multiple excel files using tFileList and display the name of files

kuwaryogi27 — Wed, 03 Apr 2019 13:06:55 GMT

Hi All,

I want to display filename's of the current excel file fetched using tFileList, can you please help me?

Regards,
Yogesh.

Re: Reading multiple excel files using tFileList and display the name of files

vapukov — Wed, 03 Apr 2019 13:19:42 GMT

Hi Yogesh,

after tFileList you could use tJavaFlex and in the main section

System.out.println(((String)globalMap.get("tFileList_1_CURRENT_FILE")));

regards, Vlad

Re: Reading multiple excel files using tFileList and display the name of files

kuwaryogi27 — Wed, 03 Apr 2019 13:24:31 GMT

Hello @vapukov ,

Thanks this worked for me.

Regards,
Yogesh.

Re: Reading multiple excel files using tFileList and display the name of files

kuwaryogi27 — Wed, 03 Apr 2019 15:02:29 GMT

Hi @vapukov ,

Can you help me in archiving the files based on their names, suppose the excel's name contain either abc or xyz in files i want to archive them on thier name basis.

Regards,
Yogesh.

Re: Reading multiple excel files using tFileList and display the name of files

joearun4u — Thu, 04 Apr 2019 11:50:09 GMT

Hi Yogesh,

If you want to archive the files based upon the file mask, you can find a option in tFileList as below

You can give the file mask to filter the files and use tFileCopy to copy the files in your required destination as follow

Thanks,

Joe

Dont forget to give Kudos/Solution if you find this tip is useful

Re: Reading multiple excel files using tFileList and display the name of files

vapukov — Thu, 04 Apr 2019 11:58:28 GMT

hi Yogesh,

if you mean as "archiving" - relocate files, the answer from @joearun4u would be good