Employee XREF

There is an enterprise datasource that brings in a number of productivity metrics by employee code. At a building level, I have a cross-reference file that can match up the employee code with their cost center and operations manager in my building. I am unable to modify the enterprise datasource, but need to create a card based on that information and my XREF table to produce metrics by cost center and operations manager. Is there any way to do this? I do have the ability to create my own datasources in our configuration, but do not have access to the underlying data that creates the enterprise datasource.
Best Answer
-
https://knowledge.domo.com/Prepare/Magic_Transforms
If you're familiar with SQL, https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows is probably where you want to go.
If not, try https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/01Creating_an_ETL_DataFlow
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Are these two datasources in Domo already? If not, can you get them there using any of Domo's connectivity options, like Workbench, email connector, Google Sheet connector, etc? Once they're in Domo and on a refresh schedule, it's a minor thing (using dataflow) to join them together to create a final datasource.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks for the reply @AS. They are both in DOMO currently. Can you point me to a resource to learn how to use the dataflow to join them?
0 -
https://knowledge.domo.com/Prepare/Magic_Transforms
If you're familiar with SQL, https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows is probably where you want to go.
If not, try https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/01Creating_an_ETL_DataFlow
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks @AS. That link was exactly what I needed!
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive