How to select distinct in workbench
Best Answer
-
Doing this in Workbench would depend on what type of data it is. Is it an ODBC connection, Excel spreadsheet, etc.?
You could do this in Magic ETL after the data is in Domo. To do this, you could use the Select Columns transform to grab only the Firm column, then use a Remove Duplicates transform to narrow it down to unique values.
Let me know how that goes for you.
0
Answers
-
Doing this in Workbench would depend on what type of data it is. Is it an ODBC connection, Excel spreadsheet, etc.?
You could do this in Magic ETL after the data is in Domo. To do this, you could use the Select Columns transform to grab only the Firm column, then use a Remove Duplicates transform to narrow it down to unique values.
Let me know how that goes for you.
0 -
I was able to fix my query in workbench and your help with ETL worked as well, thank you.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 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