topic Re: if resident in QlikView

if resident

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i have tableA which is:

numberA

i have another tableB which is:

numberB

how can i add a column in tableA if the value in tableB then i add yes, if not, add no. which is:

numberA check

1 no

2 yes

3 no

4 yes

5 yes

shall i use if(numberA resident numberB, yes, no) ? thanks a lot

Re: if resident

sunny_talwar — Thu, 29 Sep 2016 18:14:51 GMT

May be like this:

MappingTable:

Mapping

LOAD numberB,

'Yes' as Flag

LOAD * INLINE [

numberB

];

TableA:

LOAD *,

ApplyMap('MappingTable', numberA, 'No') as check

INLINE [

numberA

];

Re: if resident

rupamjyotidas — Thu, 29 Sep 2016 18:17:11 GMT

Try This

numberB:

LOAD * INLINE [

numberB

];

numberA:

LOAD * INLINE [

numberA

];

Left Join

test:

Load

numberA,

'Yes' as Check

Resident numberA where Exists(numberB,numberA);

Final:

Load

numberA,

If (Len(Check)>0,'Yes' ,'No') as Check1

Resident numberA;

Drop table numberA;

Re: if resident

maxgro — Thu, 29 Sep 2016 18:58:42 GMT

another option could be

TableB:

load * inline [

numberB

];

TableA:

load

if(Exists(numberB, numberA), 'yes', 'no') as FlagExists

inline [

numberA

];