Discussion board where members can get started with QlikView.
I have a table Office
that is connected to other tables by ID
I do not need any information about Office B. How can I remove this ?
WHERE NOT WildMatch(name, 'B')
But it only removes it from the name column. ID 2 still remains.
That's because ID 2 still exists in the other table. If you don't want it there either then you need to change the order in which you load tables:
Table1:LOAD name, ID FROM ...source1... WHERE NOT Wildmatch(name, 'B');
Table2:LOAD ID, ...other fields... FROM ...source2... WHERE Exists(ID);