Retrieve output file schema from sql table

One Star

Retrieve output file schema from sql table

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.
Community Manager

Re: Retrieve output file schema from sql table

I think you need to convert rows to columns, please refers to this KB article
Talend | Data Agility for Modern Business

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach