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

lb1234
lb1234 ⚪️
edited December 2022 in Charting

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?

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    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!**