Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Calculating two fields from different tables

Highlighted
7 - Meteor

Hello,

 

So this is the problem. I am calculating the conversion of currency according to the rate described in a master table that i have created. 

 

My main data has fields known as Sales(USD), Sales(SGD

 

I have put the exchange rate of Singapore Dollar in the master table and it looks like this:

 

Currency         Exchange Rate

SGD                0.72

 

The Sales(USD) in the main has a sales figure, say $30. 

 

I just want to be able to calculate USD/SGD (where the value of SGD is from master table), which will give me the Sales figure in Singapore Dollar.

 

I now there is another way of calling the real time exchange data, but that isnt what I am required to do here. 

 

So how can I call the value of SGD from another table?

 

Thank You for your help

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Ghosh 

 

You can filter the SGD currency from this table and use Append Fields tool, appending the field Exchange Rate to your table and using the Formula tool to make the calculation.

 

Cheers,

Highlighted
Alteryx
Alteryx

Hi @Ghosh,

 

I'd recommend using the Find and Replace tool and use the Append option in its configuration (rather than the Replace) to be able to append the relevant exchange rate that you pull from your 'lookup table' to your master table. Then use the Formula tool for the calculation.

 

Hope this helps!

Giuseppe

Highlighted
7 - Meteor

Actually this is my look up table:

clipboard_image_0.png

 

and this is my main:

 

clipboard_image_1.png

 

So the Sales SGD gets calculated using the formula: SalesUSD/Exchnge rate of SalesSGD. answer will appear in the SalesSGD column.

 

Sorry if I might have confused you guys.

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Ghosh 

 

Here's an example of what I'd do:

 

ExampleSalesCurr.PNG

 

- Add a "Currency" string before your Currency field, just for clarification

- Use Cross-Tab Tool to put that as Fields

- Append all exchange rates to your table

- Use the Formula Tool to calculate all of your Sales fields.

 

WF attached.


Cheers,

Highlighted
7 - Meteor

Thank you for your help, Thableaus. This works. 

Labels