Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What is the source of your data? If the source is a database, please share with me the SQL which you are using.
@Ravichandran Rajagopal This is the main table
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.
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.
Can you put the expectation in an excel spreadsheet and post that in here please?
Is this your expectation?
Yes @Vikram Kumar, Instead of Price and Total_price column.. Price_usd, Price_gbp.. TotalPrice_usd and so on have to be loaded
You can do this entire computation in a tMap component