Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I wanted to know extra columns like below
New:
New_Col
A
B
C
D
Old:
Old_Column
A
B
If I keep Inner Join between them then I will get A, B but I wanted to Extra Columns from New like C,D how to find out
if you only want C and D values in New table, like this
the script is
Old:
load * Inline [
Old_Column
A
B
];
New:
load * Inline [
New_Col
A
B
C
D
]
Where not Exists (Old_Column, New_Col);
used LEFT KEEP in your script like that
New:
New_Col
A
B
C
D
LEFT KEEP
Old:
Old_Column
A
B
Hi,
Can you post your expected Output?
if you only want C and D values in New table, like this
the script is
Old:
load * Inline [
Old_Column
A
B
];
New:
load * Inline [
New_Col
A
B
C
D
]
Where not Exists (Old_Column, New_Col);
Try:
New:
Load * inline [
New_Col
A
B
C
D ];
Old:
LOAD * Inline [
Old_Column
A
B ];
TempNew:
LOAD
New_Col as NC
Resident New
;
Inner Join(New)
Old1:
LOAD Old_Column as New_Col
Resident Old;
Concatenate(New)
LOAD
NC as New_Col
Resident TempNew
;
DROP Table Old,TempNew;
try this :-
New:
load * Inline[
A
B
C
D]
Outer join
Old:
load * Inline[
A
B]
Load
C,
D
resident New;