Quick way to determine number of unique values per column

I have a dataset with over 400 columns... and long story short, there are basically duplicate columns (4 different formats for each field) and I want to select the ones where there are actual values (as opposed to blanks or nulls). Is there a quick way to do this in Domo without manually having to go through?
Maybe via Sumo card....?
I'd like to be able to export a spreadsheet with all the column headers and number of unique values for each.
Best Answer
-
@NathanDorsch You can see some high-level statistics for each column in the Data tab of your dataset by toggling the statistics icon to the left of the column headers
1
Answers
-
@NathanDorsch You can see some high-level statistics for each column in the Data tab of your dataset by toggling the statistics icon to the left of the column headers
1 -
Is there a way though to export this data out so I don't have to go trhough and manually type in each one?
0 -
@NathanDorsch You could use a PivotTable card to export, but you would still have to create a count(distinct) beast mode for all 400 fields.
1 -
so I'd have to create a count(distinct) for each and every column>?
0 -
@NathanDorsch Yes, if you want to know the number of unique values in each field then you will need a distinct count.
1
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive