Dynamic column export with order

[Anonymous]

I have a table called Temp as a table structure below

Temp
====

col1, col2, col3
11,22,33
44,33,55

I need to export this table records into excel. But while exporting column header of the excel should be exported based on the reference table with respective output_name and order.

Reference Table
===============

input_column,output_colunm,order
col1,First_value,3
col2,Second_value,1
col3,Third_value,2

Expectedoutput - Excel export

output_colunm
=============

Second_value,Third_value,First_value
11,22,33
44,33,55

Note: Everything should be dynamic, in future we may add addition column in temp table and respective entry should be inserted into reference table.

[Anonymous]

First of all, are you using the Open Studio or a subscription version of Talend? The answer will depend upon this.

[Anonymous]

I am using subscription version of Talend

[Anonymous · Accepted solution]

Sorry about the delay in getting back to you. I had to figure out a good way of doing this. I *might* even write a blog on it, but I figured it would be mean to keep you waiting for that.

The fact that you are using the subscription version makes this possible. I'll demonstrate a job which does this below. You will have to modify it to accommodate your data sources.

The job looks like this.....

To see the whole post, download it here
OriginalPost.pdf

[Anonymous]

Awesome !!! Perfectly matching my requirement. Thanks for the solution.

[Anonymous]

No problem. I felt like a bit of a challenge and your question came along at the right time 🙂

[Anonymous]

I've no written a blog on this here: https://www.talend.com/blog/2019/11/11/migrate-data-between-databases-one-job-using-dynamic-schema/