topic Calculated field from multiple columns in Connectivity & Data Prep

Calculated field from multiple columns

nlsdxb — Fri, 31 May 2024 05:28:17 GMT

I want to create an "Amount Converted" field from the following

I have one column with "amount" one with "Currency" and a table that contains the "conversion rate".

what script do i write that creates "Amount Converted" that calculates "amount" * "Conversion rate" based on "Currency" column?

New to scripting so any help i can get will be appreciated

Re: Calculated field from multiple columns

Antoine04 — Fri, 31 May 2024 07:19:06 GMT

Hello,

I guess the conversion rates are in another table ?

Could you please share an overview of the table with the rates ?

Re: Calculated field from multiple columns

nlsdxb — Fri, 31 May 2024 07:57:27 GMT

Hello!

thanks for replying!

Re: Calculated field from multiple columns

nlsdxb — Fri, 31 May 2024 07:59:04 GMT

the above table has a column with "currency" which i'm using to link the two table's together

Re: Calculated field from multiple columns

nlsdxb — Tue, 04 Jun 2024 05:57:19 GMT

Solution found with the help of Deepak Kurup for giving me the answer and to Abhishek Agarrwal's video on how to do the syntax.

I joined the table that contained the values and the table that contained the currency rate. Now the two are linked with a full outer join and i can now create a calculated field of Amount Converted