topic Joining Problem in QlikView

Joining Problem

koushik_btech20 — Sat, 01 Mar 2014 09:05:42 GMT

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

Tab1:

LOAD * Inline [

Code, Value

A,1

B,2

C,3

D,4

];

Tab2:

LOAD * Inline [

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

Anonymous — Sat, 01 Mar 2014 09:12:27 GMT

Tab1:

LOAD * Inline [

Code, Value

A,1

B,2

C,3

D,4

];

outer join ( Tab1 )

LOAD * Inline [

Code,Value

A,5

B,6

E,7

F,8

]

where not exists ( Code ) ;

Re: Joining Problem

MK_QSL — Sat, 01 Mar 2014 09:13:00 GMT

Tab1:

LOAD * Inline [

Code, Value

A,1

B,2

C,3

D,4

];

Concatenate

LOAD * Inline [

Code,Value

A,5

B,6

E,7

F,8

];

Final:

Load Code, Min(Value) as MinValue

Resident Tab1

Group By Code;

Drop Table Tab1;

Re: Joining Problem

Sat, 01 Mar 2014 09:14:02 GMT

Hi,

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

Tab1:

LOAD * Inline [

Code, Value

A,1

B,2

C,3

D,4

];

Tab2:

LOAD * Inline [

Code,Value

A,5

B,6

E,7

F,8

]

where not(exists(Code))

;

Re: Joining Problem

aveeeeeee7en — Sat, 01 Mar 2014 09:18:10 GMT

Hi Koushik

See the Attachment.

Regards

Aviral

Re: Joining Problem

Sat, 01 Mar 2014 09:33:28 GMT

hi Kaushik

Tab1:
LOAD * Inline [
Code, Value
A,1
B,2
C,3
D,4
];

Tab2:
LOAD * Inline [
Code,Value
A,5
B,6
E,7
F,8
]
where not(exists(Code));