Select distinct value from table using Magic ETL

e.g. Selecting distinct date from date column using Magic ETL?
Best Answer
-
I believe you can achieve this via either the edit data -> remove duplicates or edit columns -> group by transformations. Your preference might be driven by what you want to do with the data that gets thrown out. Selecting just the date column and removing duplicates should give you a set of distinct dates in the original DataSet. Using group by lets you attach aggregates based on the other columns in addition to getting the distinct set.
1
Answers
-
I believe you can achieve this via either the edit data -> remove duplicates or edit columns -> group by transformations. Your preference might be driven by what you want to do with the data that gets thrown out. Selecting just the date column and removing duplicates should give you a set of distinct dates in the original DataSet. Using group by lets you attach aggregates based on the other columns in addition to getting the distinct set.
1 -
@magicdust, did cr1ckt's reply help you out?
0
Welcome!
Welcome!
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
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 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
- 115 Community Announcements
- 4.8K Archive