I am trying to exclude null values in a flat table by unticking the 'Include null values' checkbox, but this does not remove the rows.
Can I remove nulls values or restrict the data using an expression?
I have a column called 'Type' and I only want to return values 'XQH', 'XQC' AND 'ZBC'. Any other values I would like removed from my table.
I would have added this in the data load editor but I need to exclude this data on the front end, as the script is being used to create other tables.
Thanks in advance.