How would I pull a list of column names that have no data?
Options

lb1234
Member
Our Salesforce dev team frequently changes field names and without notifying us, so I'm trying to find an easy way to create a report showing all of the columns that contain no data as this is a sign this field was replaced with a new field or is no longer in use and we need to remove it from our ETLs and cards. Is there a way to get a list for each dataset we bring in from Salesforce showing the columns with no values? Is there also a way to pull a list of the cards or ETLs currently using these fields?
Tagged:
0
Answers
-
Have you tried using an unpivot in an Etl to convert your columns to rows then group by your metric column and count the number of values?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive