Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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 ) ;
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 ) ;
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;
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))
;
Hi Koushik
See the Attachment.
Regards
Aviral
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));