Product: TIBCO Spotfire®
How to check if a column is empty or not.
Consider the following dataset where the "Profession" column has a few empty rows.
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:
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".