How to remove empty columns from a dataset?

Kunal

I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values?

I know I can write a script using Python/R but we don't have a scripting tile in our package.

MichelleH

Hi @Kunal you can remove columns you don't need using the Select Columns tile in Magic ETL

Kunal

Hi @MichelleH , I'm trying to write a generic logic that would just let me remove all the columns with no values and something which I can use on other datasets too. I'm trying to avoid using the Select tile because I have 100+ columns and I'm trying to find a way to not do it manually