Retrieve output file schema from sql table

Anonymous — Sat, 16 Nov 2024 10:12:47 GMT

HI All
i have a sql table named schema, which has two column input_schema and output_schema.
input_schema | output_schema
a | x
b | y
c | z
apart from this table i have another table named input_table which has three columns named a,b,c and has some data in it.
Now i have to copy data of input_table into a csv file, which will have columns x,y,z.
Mapping of a,b,c to x,y,z must be according to the schema_table given above.
Thanks

Re: Retrieve output file schema from sql table

Anonymous — Tue, 13 Dec 2016 03:20:22 GMT

Hello
I think you need to convert rows to columns, please refers to this KB article.
Regards
Shong

topic Re: Retrieve output file schema from sql table in Talend Studio

Retrieve output file schema from sql table

Re: Retrieve output file schema from sql table