topic Re: how to display only differenet value from to table... in QlikView

how to display only differenet value from to table...

hamzabob1 — Tue, 04 Aug 2015 07:13:35 GMT

hello everyone,

i have one simple question can u help me out.

suppose i have two table as shown in below:

tableA:

LOAD * INLINE [

name, value

a, 1

b, 2

c, 3

d, 4

e, 5

f, 6

];

tableB:

LOAD * INLINE [

name, value

c, 3

d, 4

e, 5

];

now i want to display only uncommon name and vale.

Expected output:

name value

a 1

b 2

f 6

thanks in advance.

Re: how to display only differenet value from to table...

ramoncova06 — Tue, 04 Aug 2015 15:21:34 GMT

do you want to do this at script or front end ? do you still want to keep both tables ?

here is a quick way of doing this, though will only keep table A with the non found values

mapping

tableB:

LOAD * INLINE [

name, value

c, 3

d, 4

e, 5

];

tableA:

Load

name,

value

where applymap('tableB', name,0) = 0

LOAD * INLINE [

name, value

a, 1

b, 2

c, 3

d, 4

e, 5

f, 6

];

Re: how to display only differenet value from to table...

ramoncova06 — Tue, 04 Aug 2015 15:24:56 GMT

here using the exists function, I change the name label on tableB

tableA:

LOAD * INLINE [

name, value

a, 1

b, 2

c, 3

d, 4

e, 5

f, 6];

tableB:

LOAD * INLINE [

name1, value

c, 3

d, 4

e, 5];

noconcatenate

tableC:

load

name,

value

resident tableA

where not exists (name1, name);

Re: how to display only differenet value from to table...

maximiliano_vel — Tue, 04 Aug 2015 21:10:02 GMT

tableB:

LOAD * INLINE [

name1, value1

c, 3

d, 4

e, 5

];

tableA:

LOAD * INLINE [

name2, value2

a, 1

b, 2

c, 3

d, 4

e, 5

f, 6

]

WHERE Not Exists(name1, name2);

DROP Table tableB;

Re: how to display only differenet value from to table...

maxgro — Tue, 04 Aug 2015 21:25:11 GMT

I added some records in tableB and checked on name and value

tableA:

LOAD *, 1 as fromA INLINE [

name, value

a, 1

b, 2

c, 3

d, 4

e, 5

f, 6

];

//tableB:

join (tableA)

LOAD *, 1 as fromB INLINE [

name, value

c, 3

d, 4

e, 5

x, 20

y, 21

z, 22

];

left join (tableA)

LOAD

name, value,

if(rangesum(fromA,fromB)=1, 1) as uncommon

Resident tableA;

Re: how to display only differenet value from to table...

hamzabob1 — Wed, 05 Aug 2015 05:14:56 GMT

thanks everyone its working fine...

thanks again