topic Re: How to convert rows to column? in Talend Studio

How to convert rows to column?

shalinim1 — Sat, 16 Nov 2024 01:14:45 GMT

Hi,

I have a table which consists of column_from, column_to, conversion_rate. For example,

INR,USD,0.014

INR,EUR,0.011

INR,GBP,0.012

INR,CAD,0.018

INR,INR,1

USD,INR,74

I have connected to main table by joining with column_from in tmap component. I want to convert column_to rows as columns. so that I can use them in my job for currency conversion.

Re: How to convert rows to column?

Ravi_Rajagopal — Mon, 26 Oct 2020 15:26:33 GMT

What is the source of your data? If the source is a database, please share with me the SQL which you are using.

Re: How to convert rows to column?

shalinim1 — Tue, 27 Oct 2020 04:15:07 GMT

@Ravichandran Rajagopal This is the main table

Re: How to convert rows to column?

vikramk — Tue, 27 Oct 2020 10:25:32 GMT

Hi @Shalini M ,

Please would you mind confirming whether my understanding correct or not.

Your requirement is to bring your "column_to" rows as columns in the output?

Would it be possible to give the desired end output here. it would help to understand accurate.

Re: How to convert rows to column?

shalinim1 — Tue, 27 Oct 2020 12:50:28 GMT

Yes @Vikram Kumar , I want to make 'column_to' rows as columns.

And the output should be like

If the input currency type of price column is INR, I have to convert it into USD,GBP,EUR and so on.. and load that price which is converted into a table.

Re: How to convert rows to column?

Ravi_Rajagopal — Tue, 27 Oct 2020 13:17:24 GMT

Can you put the expectation in an excel spreadsheet and post that in here please?

Re: How to convert rows to column?

Ravi_Rajagopal — Tue, 27 Oct 2020 13:28:13 GMT

Is this your expectation?

Re: How to convert rows to column?

shalinim1 — Tue, 27 Oct 2020 13:44:20 GMT

Yes @Vikram Kumar, Instead of Price and Total_price column.. Price_usd, Price_gbp.. TotalPrice_usd and so on have to be loaded

Re: How to convert rows to column?

Ravi_Rajagopal — Fri, 06 Nov 2020 02:43:36 GMT

You can do this entire computation in a tMap component