Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marebalo
Contributor
Contributor

Exclusive join

hi sorry for my english

How can i do an exclusive outer join?

 

i let a picture that explains better

 

 

1 Solution

Accepted Solutions
lblumenfeld
Luminary Alumni
Luminary Alumni

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, Field1
1, A
2, B
4, D
];

Table2:
Load * Inline [
T2_ID, Field2
1, X
3, Y
4, Z
];

 

This is the script that will do the Exclusive Outer Join of Table1 and Table2...

-------------

 

CombinedTable:
Load
   T1_ID as ID,
   Field1
Resident Table1
Where not Exists(T2_ID, T1_ID);

Concatenate (CombinedTable)

Load
   T2_ID as ID,
   Field2
Resident Table2
Where Not Exists(T1_ID, T2_ID);

Drop Tables Table1, Table2;

-------------

Now, CombinedTable will contain:

ID       Field1       Field2
2         B
3                             Y

 

I hope this helps.

View solution in original post

1 Reply
lblumenfeld
Luminary Alumni
Luminary Alumni

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, Field1
1, A
2, B
4, D
];

Table2:
Load * Inline [
T2_ID, Field2
1, X
3, Y
4, Z
];

 

This is the script that will do the Exclusive Outer Join of Table1 and Table2...

-------------

 

CombinedTable:
Load
   T1_ID as ID,
   Field1
Resident Table1
Where not Exists(T2_ID, T1_ID);

Concatenate (CombinedTable)

Load
   T2_ID as ID,
   Field2
Resident Table2
Where Not Exists(T1_ID, T2_ID);

Drop Tables Table1, Table2;

-------------

Now, CombinedTable will contain:

ID       Field1       Field2
2         B
3                             Y

 

I hope this helps.

View solution in original post