5 Replies Latest reply: Mar 1, 2014 4:33 AM by qlik learn

# Joining Problem

I am facing a problem regarding joining two table. Suppose I have two inline table ,

Tab1:

Code, Value

A,1

B,2

C,3

D,4

];

Tab2:

Code,Value

A,5

B,6

E,7

F,8

];

Now after joining two table I want the solution as,

Code,Value

A,1

B,2

C,3

D,4

E,7

F,8

If anyone have any solution please share here...

• ###### Re: Joining Problem

Tab1:

Code, Value

A,1

B,2

C,3

D,4

];

outer join ( Tab1 )

Code,Value

A,5

B,6

E,7

F,8

]

where not exists ( Code ) ;

• ###### Re: Joining Problem

Tab1:

Code, Value

A,1

B,2

C,3

D,4

];

Concatenate

Code,Value

A,5

B,6

E,7

F,8

];

Final:

Resident Tab1

Group By Code;

Drop Table Tab1;

• ###### Re: Joining Problem

Hi,

just concatenate using where not(exists(Code))... ;D

Tab1:

Code, Value

A,1

B,2

C,3

D,4

];

Tab2:

Code,Value

A,5

B,6

E,7

F,8

]

where not(exists(Code))

;

• ###### Re: Joining Problem

Hi Koushik

See the Attachment.

Regards

Aviral

• ###### Re: Joining Problem

hi Kaushik

```Tab1:
Code, Value
A,1
B,2
C,3
D,4
];

Tab2: