topic Re: dynamically load multiple CSV files with different structure into different MySQL tables in Talend Studio

dynamically load multiple CSV files with different structure into different MySQL tables

Anonymous — Fri, 02 Nov 2018 05:42:05 GMT

Hi,

I'm new to Talend and I have a scenario where I need to load multiple CSV files with different structure into different MySQL tables dynamically and I am using Talend Enterprise version.

Can anyone please give me some options and examples.

Thanks!!

Re: dynamically load multiple CSV files with different structure into different MySQL tables

manodwhb — Fri, 02 Nov 2018 07:14:48 GMT

@Moe,check the below link.

https://community.talend.com/t5/Design-and-Development/how-to-load-multiplefiles-into-multiple-tables-and-the-have-to/td-p/25398

Re: dynamically load multiple CSV files with different structure into different MySQL tables

Anonymous — Fri, 02 Nov 2018 07:59:04 GMT

Thanks Manohar.

But for my scenario I need to load data dynamically and I am unable to load the files separately since in tfileinputdelimiter I have mentioned the schema with only one column i.e dynamic column.

Can anyone please suggest me some options.