2 Replies Latest reply: May 27, 2014 12:43 PM by Anand Chouhan RSS

    Question about keep syntax

    Matt Maino

      Hi everyone,

       

      I am currently working on a data model that connects several tables together to be used in the same qlikview document. I am confused about how the keep syntax is supposed to work. In the script I have one table called Table1, and I would like to right keep Table2 on Table1 so that all of the data in Table1 stays, but only the rows with matching fields in Table2 stay. Would the proper way of doing this be:

       

      Table1:

      LOAD *

      FROM (location)

       

      Table2:

      Right Keep (Table1)

      LOAD*

      FROM (location)

       

      Thank you