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
-
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 -
Thanks very much -worked perfectly!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive