How to find Extra Columns

[priyarane]

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

[ahmar811]

used LEFT KEEP in your script like that

New:

New_Col

A

B

C

D

LEFT KEEP

Old:

Old_Column

A

B

[settu_periasamy]

Hi,

Can you post your expected Output?

[maxgro · Accepted solution]

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

[jsingh71]

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;

[raman_rastogi]

try this :-

New:

load * Inline[

A

B

C

D]

Outer join

Old:

load * Inline[

A

B]

Load

C,

D

resident New;