Only show unique values of a column in table
Best Answer
-
@jrtomici You can use the Remove Duplicates tile when creating an ETL if it doesn't matter which row you keep:
If which row you want to keep does matter, then I would use the Rank & Window tile to help identify duplicate rows and how you want to mark them to be excluded:
https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
3
Answers
-
@jrtomici You can use the Remove Duplicates tile when creating an ETL if it doesn't matter which row you keep:
If which row you want to keep does matter, then I would use the Rank & Window tile to help identify duplicate rows and how you want to mark them to be excluded:
https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
3 -
Great, thank you. How would I approach the logic of removing duplicates only within a unique ID? I don't want to remove all duplicates, just `Num`s that appear multiple times within a corresponding ID (see example). @RobSomers thanks!
0 -
@jrtomici The Remove Duplicates tile should let you select multiple columns, so you would select the ID and Num columns to look for duplicates and in your example it would see row 2 and 3 as duplicates, and then the ETL would remove one of them and you would just be left with one row with ID of 1 and Num of 4. It would leave rows 6 and 7 alone because 2-6 and 3-6 are not duplicates. They have an example of what this looks like in the link to page about Remove Duplicates.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
4 -
Thank you so much!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive