Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
I have a shopping table that have a field "Purchase Order", and also I have a table of purchases received with same "Purchase Order" field.
For certain reasons (as filters and extra info in both tables) i don't want them to associate, but i would like to know if there's a function as match or find so I can search if table1.PO are between table2.PO, so I can add nonreceived PO's on qlik table.
Regards
HI
I would do something in script.
You could do a resident load of the PO Number from one table and join it to the other,
Something
JOIN (TABLE1)
LOAD
"Purchase Order"
1 as Flag
Resident TABLE2;
The flag would then let you know if the PO Number in Table 2 exists in Table 1
Hi @KarlaB , you can check the EXISTS function.
Exists() determines whether a specific field value has already been loaded into the field in the data load script. The function returns TRUE or FALSE, so can be used in the where clause of a LOAD statement or an IF statement.
That's exactly what i'm looking for, but I tried and qlik says "EXISTS is not a valid function".
On excel I would try as if(isnumber(match())) but qlik also does not recognize ISNUMBER function.
Dear @KarlaB , exists is a script function to use in where clause.
In Qlik to validate if a field value is a number use ISNUM.... 😉