topic Re: tFileInputDelimited dynamic filename in Talend Studio

tFileInputDelimited dynamic filename

Anonymous — Thu, 24 Jan 2019 08:31:19 GMT

Hello, how to pass parameter filename to tFileInputDelimited?
I have to parse a file that changes daily, the filename format is somefile_yyyymmdd.csv
So every day it will have different name
 
In tFileInputDelimited, I have to select the file manually?

Re: tFileInputDelimited dynamic filename

Anonymous — Thu, 24 Jan 2019 08:45:00 GMT

Hello,

Could you please try to use a tFileList component to iterate your somefile_yyyymmdd.csv file in a given directory based on a file mask pattern?

tFileList(*.csv)-->tfileinputdelmited(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) )-->output

Best regards

Sabrina

Re: tFileInputDelimited dynamic filename

Anonymous — Thu, 24 Jan 2019 10:11:13 GMT

Hello,

Depends on when you want to parse it.

If it's the same day you can use in the file name :

"somefile_" + TalendDate.getDate("yyyMMdd") + ".csv"

If you want to parse it one every week, use a tFileList then iterate into a tFileInputDelimited.

Hope it'll help.

Re: tFileInputDelimited dynamic filename

dipanjan93 — Thu, 24 Jan 2019 12:00:13 GMT

Use the below code -

((String)globalMap.get("tFileList_1_CURRENT_FILE")).replace(".csv","")+"_"+TalendDate.getDate("yyyyMMdd")+".csv"