Wildmatch function

[tipicatala]

Hi everyone

I have a table Office

name	ID
A	1
B	2

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.

[Gysbert_Wassenaar]

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