topic Re: How to find Extra Columns in QlikView

How to find Extra Columns

priyarane — Mon, 26 Oct 2015 08:04:47 GMT

Hi Community,

I wanted to know extra columns like below

New:

New_Col

Old:

Old_Column

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

Re: How to find Extra Columns

ahmar811 — Mon, 26 Oct 2015 08:15:43 GMT

used LEFT KEEP in your script like that

New:

New_Col

LEFT KEEP

Old:

Old_Column

Re: How to find Extra Columns

settu_periasamy — Mon, 26 Oct 2015 08:27:26 GMT

Hi,

Can you post your expected Output?

Re: How to find Extra Columns

maxgro — Mon, 26 Oct 2015 08:28:49 GMT

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

the script is

Old:

load * Inline [

Old_Column

];

New:

load * Inline [

New_Col

]

Where not Exists (Old_Column, New_Col);

Re: How to find Extra Columns

jsingh71 — Mon, 26 Oct 2015 08:40:12 GMT

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;

Re: How to find Extra Columns

raman_rastogi — Mon, 26 Oct 2015 08:58:36 GMT

try this :-

New:

load * Inline[

Outer join

Old:

load * Inline[

Load

resident New;