One to Many Datasets
Hi
I'd like to see if there a way to show a one to many relationship in my data set.
I have lead records on the company level. I also have contact activities. So one company can have many activities in a give month, quarter or year. I have two datasets : one for companies and one for contact activites. I'm using the ID as the unique key. Using data fusion, I though I could get a one to many type of dataset, However, this was not sucessful.
Let me know if you have encountered similar issues or whether domo has the capability to do a one to many data set.
Thanks!
Comments
-
0
-
@Lisa-Chang - A DataFusion should be able to meet your need of taking two datasets and relating them on a one-to-many basis.
So in the case of Company to Activities.
I assume that each Company has a Name and each Activity has the name of the company.
So when building the DataFusion, I would be sure I am selecting "Add Columns" and then first select my Company and the Name field and then select Activity with the corresponding Company Name field and have it do a LeftJoin.
This will go through each row on the left (in our case Company) one by one and see where it matches to Activities. So if in the first row it finds that the Company Name matches 4 different activities, it will create 4 rows.
I hope that was helpful!
You might also have some luck using ETL and doing this also!
0 -
@Lisa-Chang, did Bullokos' reply help you out?
0 -
@Lisa-Chang In addition to a Data Fusion (which should do what you want just fine) Magic ETL can also combine multiple DataSets on a common key, and will also let you clean up data in other ways. To learn more, you can go to the down arrow menu -> Domo University -> Prepare -> Magic
Best,
Matt Chandler
Domo0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive