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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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;