Discussion board where members can get started with QlikView.
I have two tables like this:
Now I want a third table which shows that OI5 is not in "Table1"!
A Listbox solution is also ok.
I tried some things with joins bit it didn't work. I also read How to compare 2 tables and put non-matching results?
but it only showed me the difference between the two tables in a listbox. See below:
LOAD * INLINE [
INNER JOIN (Table1)
WHERE "Only in One Table?"
// Here I want "OI5" as an output
if(count(OrderItem)<2,-1) as "Only in One Table?"
RESIDENT Table1 GROUP BY OrderItem
Thanks in advance!!!
Go to Solution.
LOAD OrderItem, OrderItem as OI1 INLINE [
LOAD OrderItem, OrderItem as OI2 INLINE [
LOAD OrderItem, 'Not in Table 2' as WhatsUpWithThisRecord RESIDENT Table1 WHERE Not Exists(OI2, OrderItem);
LOAD OrderItem, 'Not in Table 1' as WhatsUpWithThisRecord RESIDENT Table2 WHERE Not Exists(OI1, OrderItem);
View solution in original post
May be like this:
LOAD OrderItem2 as OrderItemDifference
Where Not Exists(OrderItem, OrderItem2);
LOAD OrderItem2 as OrderItem
DROP Table Table2;
Wow great you're awesome!