Insert Multiple .csv File Into MySQL Table

[hilmandenis]

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.

[manodwhb]

@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

[Ganshyam]

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