Discussion Board for collaboration on QlikView Scripting.
hello every body
i have two table :
LOAD * INLINE [
Where not Exists (ID);
result is :
but i want add other condition in where syntax ; so that i check Num1 = Num2 also
Where not Exists (ID) and (Num1=Num2);
but send error . what can i do for resolve it?
Go to Solution.
My expectation from result is :
because in my condition ( Where not Exists (ID) and (Num1=Num2) )
1. not exists(ID)
ID 16110001 is common field in Table1 and Table2 and should not come to result
but when we have Num1=Num2 ; so we have ID 16110001 too in result.
You cant in this case join both table then use Num1=num2
Load * From Table1
Drop table Table1;
Use below code may be it will help you:
Where not Exists (ID1,ID);
Op: will be
More help please find app.
I Think this doesn't make sense.
ID result don't have Num1 because they "not Exists" in Table1.