I searched some posts and tried but still not fully understand the where exists function,
show my code as below,
First: LOAD F1 as F1Reduce,F2 INLINE [ F1, F2 1, North 2, South ];
Second: LOAD * INLINE [ F1, F2 1, North 2, South 3, West ];
//goal: get the West to a single table by searching the field F1 value in First table, ==> the "3,west" not exist in First
Third: NoConcatenate load * Resident Second where not exists(F1Reduce,F1); //cannot work
tried:
where not exists(First.F1Reduce,F1); //cannot work
where not exists(F1,First.F1Reduce); //cannot work
where not exists(F1,F1Reduce); //cannot work
then I tried another method, via the field F2,
Third: NoConcatenate load * Resident Second where not exists(F2); //because F2 already loaded in First table, here only offer one field F2 to search, cannot work.
where not exists(First.F2, F2); //ok then, by designate the searching file First.F2, failed ..
First:
LOAD F1 as F1Reduce,F2 INLINE [
F1, F2
1, North
2, South
];
Second:
LOAD * INLINE [
F1, F2
1, North
2, South
3, West
];
//goal: get the West to a single table by searching the field F1 value in First table, ==> the "3,west" not exist in First
Third:
NoConcatenate load * Resident Second
where not exists(F1Reduce,F1); //cannot work
Drop Table First, Second;
