topic Re: Building Tables in PSQL on a monthly basis in Talend Studio

Building Tables in PSQL on a monthly basis

Anonymous — Wed, 10 Apr 2019 12:09:46 GMT

Hell all,

we gonna constantly upload data onto our PSQL db. Enclsoed you can see my ETL process.

What can I do to create a new table for each month by getting the date information outta file names?

file name: XXX_XXXXXX_date_XXXX.csv

Thanks!

joearun4u — Wed, 10 Apr 2019 12:26:25 GMT

The below article is used for getting the table name from DB, whereas youc an change it for files in the input component.

Thanks,

Joe

akumar2301 — Wed, 10 Apr 2019 14:38:52 GMT

String filedate = filename != null && filename.split('_').length > 2 ? filename.split("_")[2] : "Date Not Found" ;