Comparing two values in two tables

[#1]

Hi All,

I am fairly new to Qlikview. I have come across a problem.

I have loaded the names of places from an excel sheet in the script. in the next table, i would like to check if a column name present in this tables has values same as the names imported earlier. if it does, i would want to set a flag as yes else as no

It would be something like this

LOAD Name

FROM

(ooxml, embedded labels, table is Sheet1);

Doc1:

LOAD

user as User1 ,

if( user=name,yes,no) as flag

FROM

(ooxml, embedded labels, table is Sheet1);

I need help in framing the if statement for this

[kaushiknsolanki]

Hi,

You should use the exists function. like below.

LOAD Name

FROM

(ooxml, embedded labels, table is Sheet1);

Doc1:

LOAD

user as User1 ,

if(Exists( user,Name),'yes','no') as flag

FROM

(ooxml, embedded labels, table is Sheet1);

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

i tried this. However there was an error which said Name is not found..

[kaushiknsolanki]

Hi,

use the same field name as it is in your source, because qlik is case sensitive.

Regards,

Kaushik Solanki

[#5]

please check this link Compare two column values and create a new column

[#6]

Hi ,

I have used the same upper case in both the instances. However there is still an error which says Name not found

[saimahasan]

You can join the two tables and then put the if condition as

if(User=Name,'yes','no')

[kaushiknsolanki]

Hi,

Is it possible for you to share the data with us.

Regards,

Kaushik Solanki