8 Replies Latest reply: Jul 1, 2017 3:13 PM by Andrew Walker RSS

    How can I filter by Empty Values?

    Jaime Arroyo

      Hi, I need to know how could i filter by empty values.

       

      I Have 2 tables with a variables called:

       

      1:

      DEN_ITEMS, DESCRIPTION_OF_ERROR 

      1, A

      2, B

      3, C

      4, D

      5, E

      6, F

      7, G

      8, H

       

      2:

      DEN_ITEMS, TYPE OF ERROR

      1, Z

      2, Y

      3, X

      6, W

      8, V

       

      Mainly, I need to know, which DEN_ITEMS doesnt have a TYPE OF ERROR.

       

      I need a flag that allow me to filter by all the DEN_ITEMS that doesnt have.

       

      Ex:

       

      DEN_ITEMS, DESCR..., TYPE OF ERROR

      4, D , Empty

      5, E , Empty

      7, G, Empty

       

      Thanks

       

      stalwar1