Eliminate columns with null values when reading in excel from browse

[wonka1234]

Hi,

How can I filter out columns with all nulls values ?

is there a way to do this?

Thanks.

[Prometheus · Accepted solution]

There are a couple of ways you can do it.

1) You can use a Select tool to deselect the fields you don't want. It's not dynamic, so if your data source changes and you end up with more columns or differently named columns that are all nulls, you'll  have to manually deselect those fields. 

2) You can use the Data Cleanse tool to remove null columns.

 

[binuacs]

@wonka1234 Data Cleansing tool is an option to remove the columns with all Null values

[DanielG]

I agree with @Prometheus and @binuacs -- Easiest way to do it is Data Cleanse as I assume in production you wouldn't know which columns will be fully blank beforehand.

Though I kind of miss the Transpose/Crosstab approach (or was it Crosstab/Transpose...) from before the Data Cleanse Tool had that functionality.  :)

[ishan_dania]

Could you please upload your data file
Thanks