NULL not Showing - Cannot remove Empty Fields from Output

Hey Team,

This should be a simple ask [for you clever people]

I and making a join and trying to remove fields that are empty. However, the blank fields are simply empty and therefore not being picked up when looking for NULL fields. Therefore, blank Fields remain in the output.

Where am I going wrong?

Thank you 🙂

Output

Accepted answers

afv2688

Hello @Commods,

You can also use the multifield formula for this. This will apply the same formula for different fields:

You just need to deselect where you don't want the filter to be applied. With that and selecting the 'dynamic' option it will take the new appearing fields and apply the same rule.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

All comments

JosephSerpis

Hi @Commods can you not change your filter from !IsNull to !IsEmpty as this will find the null and empty fields and filter them out? This snapshot from the documentation showcases this.

afv2688

Hello @Commods,

Emtpy values and null values are different, they dont represent the same information.

When you have null values and want o check something you sould use "IsNull([Field1])"

On the other hand if the fields are empty you need to use "Isempty([Field1]])"

You can also check if your fields are empty or null depending on the color of the bar under the field (like on the image I shared):

- Yellow -> Null values

- Grey -> Empty values

Regards

Commods

Thank you,

I think my question is why do the cells show empty? How can I get them to display Null?

Normally empty cells show as null:

But mine are showing nothing (empty):

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335