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:
When you use Right Join the join as you told is perform but the you get two tables in the model while if you use right join the second table that is Table2 you not get because all its id available on the Table1.