Detection of null values in multiple columns

[Chaoued]

I have several columns and I wanted to restore only the columns that had at least one null value, preferably without transposing the table because it is large (if there is an optimal solution on the perfermance side).

[Deano478]

@Chaoued can you share some sample data as its hard to just visualise this ?

[OllieClarke · Accepted solution]

Hi @Chaoued 

If your columns aren't changing, then this approach will work without pivoting

You can CountNulls in the summarise tool, so you can inspect that,

or if you want it to be more dynamic, then we can use those fields to dynamically select just the columns which contain at least 1 null


The summarize tool isn't dynamic, but everything downstream is.

N.B. I used the generate rows to make my data big; I'd suggest reducing the number it's generating if you want to test, as 400m rows is probably a bit overkill.

Hope that helps,

Ollie