Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);