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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 42 AI and Machine Learning
- 22 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive