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

    Exclude null

    Raman Singh

      Hi,

       

      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.

       

       

       

      stalwar1