...akshya,003,35000 ];
EmployeeAddresses:
Load
Ename as Name,
Salary
Resident Employee whereExists (Salary) >20000;
but this code will show all the existing values..
&n...
When using WHERE NOT Exists(<fieldName>) clause in a LOAD statement, the resulting table only contains a single row for each not-existing value of <fieldName> For example, c...
...lready existed I tried adding a WHERE clause WHEREEXISTS (Records). This got an error "wrong syntax near Records". Did a little more digging, saw that I apparently need the field name from both the exist...
...WF';
and this works, but when I change "where test_SYSTEM_CD <> 'CWF';" to "where not exists(test_SYSTEM_CD,'CWF');" it returns 0 results. this would probably only save me a few seconds, but i am m...
...ow my task is to find how many of those products are missing. I guess we need to use WHEREExists, can someone suggest me what should I do next. Thanks and Regards, Bikash
...irst) LOAD * INLINE [ F1, F2 1, North 2, South 3, West 4, East 3, West1 4, East1 ] where not Exists(F1Reduce,F1); //Loads records where F1's value not present in Table : First drop Field F...
I'm trying to pull information from one table, while excluding anyone who exists in another table, then using it in a filter pane. For example.... Pull all entities in table A who have never b...
Hello Experts,
I am confused on the logic of "WhereExists" when using at a Concatenated Field.
My scenario is to load the matching fields of Field_1 and Field_2 of Table_B to T...