loop with tFileList

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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