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 🙂
Solved! Go to Solution.
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.
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
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):
Use the following command on the formula tool for the Client_Domain:
IF IsEmpty([Client_Domain]) THEN Null() ENDIF
Do the same for the Client_Logon
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
To remove the empty fields I am CountNotNull in summary to the identify =0 to remove blank fields.
Appreciate that I can write this as formula, but I have 47 fields that can vary as the input query is executed daily.
Hope this makes sense - thank you for the quick turnaround in replying 🙂
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
Thank you, this worked but deselected:
Selected:
This was my first time using the multifield tool (unlikely to be my last)
Thank You Kindly