Converting currency
I have some data which contains revenue but in USD, because the data vendor is US-based, but all our other numbers are GBP. Any ideas on a way to convert tjhis into GBP? Perhaps pull some public currency data into a table and then I can do a currency calculation in beast mode or a tranform? Mainly interested in where and how to pull the data
Best Answer
-
So I found the European Central Bank has a link with conversion rates on it:
http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml
And info on it:
So here's how you can put it to use (the data updates daily btw).
Go to your Data Center and add a new Cloud App. Search for XML and choose the XML Advanced connector.
First setup your XML account (this can be gibberish as it's not actually needed for this, but here's the info on the connector XML Info)
Now here's the info you actually need:
Connection Method set to
HTTP Request
Enter the URL to your XML File:
http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml
Do you Require Additional Options:
Yes
Do you Require Attributes in Data:
Yes
Enter Fields to Exclude:
subject,Sender_name,Cube_Cube_Cube
Parser:
Recursive XML Parser
The rest you can leave blank or default. After that schedule your dataset and here's your results:
Hopefully that helps get you what you need.
Sincerely,
Valiant**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
Thanks very much -worked perfectly!
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有