Using two different datasets with ETL calculator
Comments
-
Hi Feyo,
Seems to me like this would be a join. It depends at least a little bit on how your data is set up, but the easiest could simply be a cross join between the two datasets (but that could be a cartesian product if you're not careful). You could do another join type depending on which columns you have in common between the two datasets. This could be accomplished in Magic ETL, MySQL, or Blend based on what your data looks like.
I'd start there.
2 -
Yes, you will have to join the datasets before using the calculator tile.
I would not recommend a cross join. You should be able to join on the Currency Iso code.
I would first select only the currency iso code and exchange rates from that table and then join those two rows to your main data set on the iso codes.
Once you have the amount, the iso code, and the exchange rate in the same data table, you can use the calculator tile to convert.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
That worked smoothly. Thanks for your help!
0 -
I’ve done a join and it seems to have worked. Thanks for your help Rich.
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
- 603 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
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive