Discussion Board for collaboration related to QlikView App Development.
hi sorry for my english
How can i do an exclusive outer join?
i let a picture that explains better
The was this is done is not really a join, but simulates one...
First I'll create two tables in my app (you already have two tables.)
Table1:Load * Inline [T1_ID, Field11, A2, B4, D];
Table2:Load * Inline [T2_ID, Field21, X3, Y4, Z];
This is the script that will do the Exclusive Outer Join of Table1 and Table2...
CombinedTable:Load T1_ID as ID, Field1Resident Table1Where not Exists(T2_ID, T1_ID);
Load T2_ID as ID, Field2Resident Table2Where Not Exists(T1_ID, T2_ID);
Drop Tables Table1, Table2;
Now, CombinedTable will contain:
ID Field1 Field22 B3 Y
I hope this helps.
View solution in original post