Quickly remove all columns containing only Null/Blank values
The recently introduced Column Quality feature in the Query Editor allows us to identify Valid, Error and Empty values in each column.
It would be great if we could quickly and easily remove all columns that only contain Null/Blank values.
I recently had a situation where I'd loaded a table containing 100 or so columns into the Query Editor and I had to manually work through these removing all such columns - which was at least half of them.
Having such a feature avaialble in the Query Editor wold be fantastic, and it may also be useful to have something very similar in the Data View which hides all such columns.
Taran Sohal commented
This sounds really useful, particularly with large datasets where a lot of manual removal may be needed