Hi I had a question about creating a view by joining two tables in the data tab of a card.

I am trying to join two tables to create a view in a DOMO card but I am running into a weird issue. Table 1 has 42.3 million rows and table 2 has 158K rows. When I do a left outer join to table 1 I am getting 297 million rows of data. Why am I getting more data than the two tables themselves it should be less data, not more.
Answers
-
@Utz Joins can return more rows than both tables combined if multiple matching rows are found between the two tables. In this case, it sounds like you want to return the same number of rows from your left table, but the same ItemNumbers appear multiple times in your right table.
Without knowing the nuances of your specific datasets, I recommend figuring out how to make ItemNumber unique in your right table before joining (most likely in a dataflow). I also suggest reading the knowledge base article that explains how granularity affects joins:
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 796 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive