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

[BJones1]

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.

[anselmopeixoto]

Hi @Boadil Jones​ 

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

[BJones1]

Im using the free version.

[Anonymous]

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