3 Replies Latest reply: Jul 17, 2017 2:49 PM by Ryan Minaker RSS

    Where Exists function with 'and' ?

    Ryan Minaker

      Hi,

       

      I have a question about the Where Exists function. I'm using this to successfully load data from one table only where it exists in another (which I believe is proper use).

       

      Example:

      Where Exists ([First_ID], [Second_ID]);

       

      However, from the table with the [Second_ID], I'd also like to specify a additional value to load.  Something like, load only values in Second_ID, where they have a match in First_ID, but also load '-1' from Second_ID.


      Is something like this possible? Thanks in advance!


      R.

       

       

      for_qlik.png