Anyone else wanting to join to the same table multiple times in a view?
Best Answer
-
Figured it out, but you'll have to use the Advanced SQL Editor in dataset views. Once a dataset view is converted to an Advanced SQL dataset view it cannot be reverted back.
If I solved your problem, please select "yes" above
0
Answers
-
You could make duplicate views and bring those in as additional datasets to join twice more.
If I solved your problem, please select "yes" above
1 -
@ColemenWilson That is an interesting thought… but I need to join it back 9 times…. SAP Vistex tables are really a pain.
0 -
Figured it out, but you'll have to use the Advanced SQL Editor in dataset views. Once a dataset view is converted to an Advanced SQL dataset view it cannot be reverted back.
If I solved your problem, please select "yes" above
0 -
@ColemenWilson I also learned the SQL editor is the way to test SQL you are passing to the CLI tool. The syntax is not obvious and the error messages are useless. I was trying to pass a where column is not null to a CLI export and finally found it needs to be where column != null. At least I think that was it. I had not wanted to use the SQL editor because it says you will not be able to go back but you can just cancel and not save after testing your SQL. OH, and the SQL editor answers the original question but I do not see a "yes" button for that answer.
0
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
- 755 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