Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

koushik_btech20
Contributor

Joining Problem

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...

Tags (1)
1 Solution

Accepted Solutions

Re: Joining Problem

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 ) ;

5 Replies

Re: Joining Problem

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 ) ;

MVP
MVP

Re: Joining Problem

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;

Not applicable

Re: Joining Problem

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))

;

aveeeeeee7en
Valued Contributor III

Re: Joining Problem

Hi Koushik

See the Attachment.

Regards

Aviral

Not applicable

Re: Joining Problem

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));