Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
How to check if a column is empty or not.
Solution:
Consider the following dataset where the "Profession" column has a few empty rows.
Dataset:
Name Age Profession
sherlock 40 ""
Watson 38 Doctor
One method to identify the empty values is by using a calculated column with the following expression:
If(Len([Profession])=0,"Empty","Not Empty")
The above expression calculates the length of the column "Profession". If if the length is 0, it will display "Empty" otherwise it will result in 'Not Empty".