Retrieve output file schema from sql table

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

Re: Retrieve output file schema from sql table

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog