Joining on table multiple times
We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect.
The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all reference the employee table. In DOMO I have brought in a raw transactional data set that has columns for each of the above fields that are bringing in the internal ID, I have also brought in a raw employee table that has the internal ID and the name info, essentially we need to join back on the employee table for each of those columns to bring in the name instead of the internal id for each.
From what I can see magic ETL won't let you bring in a dataset more than once so I am stumped on how to accomplish this, I would appreciate any help on this.
I'm hoping it is just a lack of experience in DOMO and not a lacking feature.
Best Answer
-
You can use the input multiple times, just drag lines from the input to additional tiles.
You could then join the data as needed.
If I solved your problem, please select "yes" above
0
Answers
-
You can use the input multiple times, just drag lines from the input to additional tiles.
You could then join the data as needed.
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive