topic Re: Loading csv file name into a MS SQL table in Talend Studio

Loading csv file name into a MS SQL table

MaxIT — Sat, 16 Nov 2024 03:00:18 GMT

I need to load data from different csv files into a MS SQL table.

I'm already able to add an additional column with the Load Date as GETDATE().

I'd like to load the csv File Name as well.

Any idea?

Thanks

Re: Loading csv file name into a MS SQL table

manodwhb — Thu, 12 Mar 2020 10:14:56 GMT

@MaxIT , if you are using tfilelist to list the files and iterate file by file then in tmap or in tJavarow you can use the global variable of tfilelist.

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

Re: Loading csv file name into a MS SQL table

MaxIT — Thu, 12 Mar 2020 10:46:02 GMT

It works with the tMap.

Thanks