Hi All,
I have no idea how to remove the empty records, please see example below.... the data is in the TEXT format. Please help and advise.
Big thanks!
Flora
Solved! Go to Solution.
Hi @florayaoyao
A filter with the expression:
!IsEmpty([CUST NO]) AND !IsEmpty([CUST NAME]) AND !IsEmpty([CONTACT SITE ID])
(etc. until it is specific enough not to remove genuine records)
would give you all non-blank rows from the true output of the filter
Thank you! This works perfectly! :)