Join Issue
Best Answers
-
Hi @Fadem
What exactly is your issue? What are you getting currently and what are you expecting? Which tool are you utilizing to do you join? View? Magic? MySQL?
DataSet Views and Magic ETL allows you to specify the join type in the UI. MySQL you need to specify either LEFT, RIGHT or FULL OUTER before your join to do a non-inner join.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
LEFT JOIN, RIGHT JOIN and OUTER JOIN will all return NULL values if it can't find a match between your two tables based on your join condition. This website may help explain the differences between the different join types: https://www.w3schools.com/sql/sql_join.asp It's working correctly based on your join columns and condition. What are you expecting to see with your joins?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@Fadem if your join keys are two text columns, it is likely a data issue. Extra spaces and capitalization are two common reasons why rows don't match when you think they should. I would use the String Operations tile and trim spaces on both ends of your text. I would also convert the fields to upper case. Then try joining on the commonly formatted columns.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Hi @Fadem
What exactly is your issue? What are you getting currently and what are you expecting? Which tool are you utilizing to do you join? View? Magic? MySQL?
DataSet Views and Magic ETL allows you to specify the join type in the UI. MySQL you need to specify either LEFT, RIGHT or FULL OUTER before your join to do a non-inner join.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Hi @GrantSmith, I am using magic ETL 1 and getting null columns on either of the two datasets I am using depending on join type when I do a left join the right data set is null and vice versa but when I do a full outer join my smaller data columns are returning null. The only join that's working is the inner join but that leaves me with 7 rows.
0 -
LEFT JOIN, RIGHT JOIN and OUTER JOIN will all return NULL values if it can't find a match between your two tables based on your join condition. This website may help explain the differences between the different join types: https://www.w3schools.com/sql/sql_join.asp It's working correctly based on your join columns and condition. What are you expecting to see with your joins?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@Fadem if your join keys are two text columns, it is likely a data issue. Extra spaces and capitalization are two common reasons why rows don't match when you think they should. I would use the String Operations tile and trim spaces on both ends of your text. I would also convert the fields to upper case. Then try joining on the commonly formatted columns.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@GrantSmith I am expecting to at least get the 7 matching rows in all the other joins. I don't know why it's giving me all nulls.
0 -
@MarkSnodgrass Thank you looks like it was a filter issue.
0 -
@GrantSmith Thank you for your continues help it was a filter issue.
0 -
Hi @MarkSnodgrass - Good day, can I ask for your help. I'm joining two dataset, one from a dataset view and the other one from an email connector. My join keys are two text columns, specifically an email address. There should be a match but I'm not getting anything. I've already tried using the String Operations tile to trim both spaces on both texts, I've also tried the Add Formula tile using the Upper function on both texts but still I'm not getting any match on my left join.
Thank you!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive