Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

How to find Extra Columns

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

if you only want C and D values in New table, like this

1.png

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

View solution in original post

5 Replies
ahmar811
Creator III
Creator III

used LEFT KEEP in your script like that

New:

New_Col

A

B

C

D

LEFT KEEP

Old:

Old_Column

A

B

settu_periasamy
Master III
Master III

Hi,

Can you post your expected Output?

maxgro
MVP
MVP

if you only want C and D values in New table, like this

1.png

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
Partner - Specialist
Partner - Specialist

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
Partner - Creator III
Partner - Creator III

try this :-

New:

load * Inline[

A

B

C

D]

Outer join

Old:

load * Inline[

A

B]

Load

C,

D

resident New;