1 Reply Latest reply: Jul 18, 2018 6:54 AM by Sunny Talwar RSS

    Exclude null

    Raman Singh



      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.