Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Wildmatch function

Hi everyone

I have a table Office

nameID
A1
B2

 

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,

            ID

FROM [blablabla]

WHERE NOT WildMatch(name, 'B')

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

 

 

Labels (3)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Wildmatch function

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


talk is cheap, supply exceeds demand