topic Wildmatch function in QlikView

Wildmatch function

tipicatala — Sat, 16 Nov 2024 20:48:41 GMT

Hi everyone

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 ?

I try

LOAD name,

FROM [blablabla]

WHERE NOT WildMatch(name, 'B')

But it only removes it from the name column. ID 2 still remains.

Gysbert_Wassenaar — Thu, 23 May 2019 13:16:19 GMT

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);