topic Re: Insert Multiple .csv File Into MySQL Table in Talend Studio

Insert Multiple .csv File Into MySQL Table

hilmandenis — Sat, 16 Nov 2024 01:39:06 GMT

Hi Everyone,

I really really new to Talend and I need to build a model to insert multiple .csv files to MySQL table. I already successfully downloading multiple .csv files from SFTP to my local and now I need to export it. After reading from multiple sources, I create a model like this

After I run the model, it just finished without showing error. I open MySQL and the table is created but there is no data inside it. I noticed that 0 rows occured after the tFileInputDelimited. This is my detail on tFileInputDelimited.

Please help me what is wrong with my model. Thank you.

Re: Insert Multiple .csv File Into MySQL Table

manodwhb — Tue, 18 Aug 2020 11:13:54 GMT

@Hilman Utomo , you need to use the below global variable for tFilelist in tFileIinputDelimited>> file name/Stream with out double quotes.

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Thanks,

Manohar

Re: Insert Multiple .csv File Into MySQL Table

Ganshyam — Mon, 07 Sep 2020 11:57:43 GMT

Hi,

You can create one intermediate text file and write all the csv data into this file and then use this data from file to write into DB table in one go.

Regards