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

lb1234
lb1234 Member
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?

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

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

Categories