topic Re: How to write data from a tdbinput to csv file when no schema is known in Talend Studio

How to write data from a tdbinput to csv file when no schema is known

BJones1 — Fri, 15 Nov 2024 21:33:36 GMT

Hi all.

I have a job that reads a txt file with some table names. The job needs to use that name to populate a tdbinput (select * from tablename) and from there write that data into a csv file. The challenge is to write the data not knowing the table schema.

Thanks.

Re: How to write data from a tdbinput to csv file when no schema is known

anselmopeixoto — Thu, 20 Jul 2023 19:20:51 GMT

Hi @Boadil Jones

Please take a look at Dynamic schemas. However, this is a subscription only feature.

Re: How to write data from a tdbinput to csv file when no schema is known

BJones1 — Thu, 20 Jul 2023 19:26:56 GMT

Im using the free version.

Re: How to write data from a tdbinput to csv file when no schema is known

Anonymous — Fri, 21 Jul 2023 03:57:23 GMT

It's impossible to achieve it with free version, you have to define the schema to map the returned fields of query.