topic Create a new field in a table if exist values in another table in QlikView

Create a new field in a table if exist values in another table

caccio88 — Sun, 20 Dec 2015 21:11:39 GMT

Ho everyone,

what i would like to do is to create a new field in the first table if exist values in another table.

Table1:

LOAD * INLINE [

];

Table2:

LOAD * INLINE [

];

What I'd like to do is to create a "B" field in the Table1 where the values are:

- "OK" if the value in the field A of Table1 exist in the field A of Table2;

- "KO" if the value in the field A of Table1 does not exist in the field A of Table2.

Is that clear enough?

The field "B" in the "New" Table1 should be:

Here attached my qvw example.

Thank u all.

Filiberto

Re: Create a new field in a table if exist values in another table

MarcoWedel — Sun, 20 Dec 2015 21:50:28 GMT

Hi,

one solution could be:

Table2:
LOAD * INLINE [
    A
    2
    3
    4
    10
    11
    12
];

Table1:
LOAD *, 
    If(IsNull(Lookup('A','A',A,'Table2')),'KO','OK') as B
INLINE [
    A
    1
    2
    3
    4
    5
    6
    7
    8
];

hope this helps

regards

Marco

Re: Create a new field in a table if exist values in another table

sunny_talwar — Sun, 20 Dec 2015 23:36:05 GMT

Another solution could be using Mapping Load:

Table2:

Mapping

LOAD * INLINE [

A, B

2, OK

3, OK

4, OK

10, OK

11, OK

12, OK

];

Table1:

LOAD A,

ApplyMap('Table2', A, 'KO') as B;

LOAD * INLINE [

];