topic Re: How to get file name in Talend Studio

How to get file name

_AnonymousUser — Sat, 16 Nov 2024 12:29:56 GMT

Hi,
I want to upload a csv file into sql server table. I need get the file name and use the file name in the job. The file name pattern is "nl_accounts_yyyy.csv". I want to exact the 'yyyy' and store it in table. how i can do that?
thanks!

Re: How to get file name

ytuzet — Sun, 18 Dec 2011 09:29:55 GMT

you can use a tfilelist for that, even if you iterate only on one file
put a tfilelist on your job plug iterations on on a tjavarow
in the tjavarow press <ctrl>+<space> it will propose a list of variables choose the one you want from tfilelist

Re: How to get file name

Anonymous — Mon, 19 Dec 2011 09:54:30 GMT

Yang,
I would do the following.
tFileList --> tFixedFlowOutput --> tMssqlOutput
Following code in tFixedFlowedInput:
StringHandling.RIGHT(StringHandling.LEFT(((String)globalMap.get("tFileList_1_CURRENT_FILE")),StringHandling.LEN(((String)globalMap.get("tFileList_1_CURRENT_FILE")))-4),4)

If you want to load the file in your database and have the year in an extra column you can do the following:
tFileList --> tFileinputdelimited--> tMap --> tMssqlOutput
In the extra column in the output part of the tMap you can put the same code from the tfixedflowinput. Every record will then have the year of the file in an extra column.
See attached screenshots.
Regards

Re: How to get file name

_AnonymousUser — Mon, 19 Dec 2011 11:23:25 GMT

thanks for reply!