Joining Problem

[koushik_btech20]

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

[Anonymous · Accepted solution]

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

[MK_QSL]

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;

[#4]

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]

Hi Koushik

See the Attachment.

Regards

Aviral

[#6]

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