topic Re: Dynamic column export with order in Talend Studio

Dynamic column export with order

Anonymous — Mon, 28 Oct 2019 16:44:26 GMT

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.

Re: Dynamic column export with order

Anonymous — Mon, 28 Oct 2019 17:40:41 GMT

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

Re: Dynamic column export with order

Anonymous — Mon, 28 Oct 2019 18:45:16 GMT

I am using subscription version of Talend

Re: Dynamic column export with order

Anonymous — Tue, 29 Oct 2019 11:19:10 GMT

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

Re: Dynamic column export with order

Anonymous — Wed, 30 Oct 2019 15:01:27 GMT

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

Re: Dynamic column export with order

Anonymous — Wed, 30 Oct 2019 15:10:30 GMT

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

Re: Dynamic column export with order

Anonymous — Wed, 13 Nov 2019 10:41:46 GMT

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/