Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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