UKanExcel (Mark Robinson @ Cloud2 Ltd) on 04 Jan 2019 18:14:16
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.
- Comments (5)
- Merged Idea (3)
RE: Quickly remove all columns containing only Null/Blank values
Does anyone have any idea why this hasn't been implemented yet? Would it be that difficult technically?It would be a very VERY beneficial function.
RE: Quickly remove all columns containing only Null/Blank values
Can we please a button to remove all the empty columns in a table?
Sometimes, particularly when using new data sources, you don't exactly what columns you might need and some tables have hundreds of columns so it would be nice to be able to delete all the empty columns in one shot
RE: Quickly remove all columns containing only Null/Blank values
This sounds really useful, particularly with large datasets where a lot of manual removal may be needed