How to join to a table multiple times?
I'm struggling to replicate a simple type of join my company does all the time in SQL Server within a Domo DataSet view. Perhaps this isn't possible to do yet. I'm hoping someone can help out.
Attached photo which has most of the complexity removed, but shows what I'm trying to do. We see "Transactions" in one table, and "Transaction_Contacts" (the buyer and seller involved in each transaction) in the other. Each transaction has 1 buyer and 1 seller.
In SQL Server, I use "table aliases" to JOIN to the Transaction_Contacts table TWICE. I use "column aliases" to rename the output columns, to become "SellerName" or "BuyerName" as appropriate. The output shown at the bottom is what the customers are expecting to see.
This is easy in SQL Server, as shown in the sample code at the bottom. When I try to create a Domo Dataset View, I can join the "Transaction_Contacts" table once, but if I try to add it again. it's greyed out/disabled. Does anyone know why? Is there a better way to do this? (I'm sure I could create an ETL but would like to avoid the complexity if possible due to understaffing.
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部