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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive