Hello,I want to join a table, but when the field action is "action 1" it should not join, but also not all other lines in the ID
Thank for the help!
tmp:LOAD ID FROM ...source... WHERE action = 'action1';
IDs:LOAD ID FROM ...source.. WHERE Not Exists(ID);
DROP TABLE tmp;
data:LOAD ID, action WHERE Exists(ID);
DROP TABLE IDs;
View solution in original post