topic Re: loop with tFileList in Talend Studio

loop with tFileList

Anonymous — Sat, 16 Nov 2024 05:02:52 GMT

Hi,

I am looping with tFileList in a folder that has several files with almost the same name, just change the initial number, for example
01_January.csv,

01_February.csv,
02_January.csv,

02_February.csv
03_January.csv ...

and I need only to import to postgreSQL those from January and then February. I'm using FileMask with the option "*_January.csv" but it doesn't work, someone knows how I can fix this.

Thanks you

Re: loop with tFileList

Anonymous — Wed, 07 Aug 2019 14:40:50 GMT

Hi,

Its working fine for me. Please refer the screen shots and could you please compare your job with mine?

output

input

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: loop with tFileList

Anonymous — Wed, 07 Aug 2019 14:59:18 GMT

Hi
Nikhil Thampi

thanks for your answer, what you helped me already had it,

the problem is about the tFileList that does not recognize

"* _January.csv" to only import the January files.

thanks

Re: loop with tFileList

Anonymous — Wed, 07 Aug 2019 15:01:39 GMT

Hi,

Could you please change "* _January.csv" to "*_January.csv"?

I could see an extra space in your version. I hope it will resolve the issue. Please spare a second to mark the topic as resolved 🙂 Kudos will be a bonus!

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: loop with tFileList

Anonymous — Wed, 07 Aug 2019 15:03:21 GMT

sorry space does not exist, it was a mistake to write the message

Re: loop with tFileList

Anonymous — Wed, 07 Aug 2019 15:07:02 GMT

Hi,

Since its working for ideal condition (like I showed in my job), you will have to verify whether there is any name change in your input files at your end. It could be space, slight deviation in case for alphabets etc. Once its resolved, the job should work fine like in sample job.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved