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.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 280 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 586 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive