topic Re: Comparing two values in two tables in QlikView

Comparing two values in two tables

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Comparing two values in two tables

kaushiknsolanki — Wed, 17 Aug 2016 11:25:59 GMT

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

Re: Comparing two values in two tables

Wed, 17 Aug 2016 12:02:04 GMT

Hi Kaushik,

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

Re: Comparing two values in two tables

kaushiknsolanki — Wed, 17 Aug 2016 16:10:52 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: Comparing two values in two tables

Thu, 18 Aug 2016 04:21:41 GMT

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

Re: Comparing two values in two tables

Thu, 18 Aug 2016 05:05:16 GMT

Hi ,

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

Re: Comparing two values in two tables

saimahasan — Thu, 18 Aug 2016 05:56:00 GMT

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

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

Re: Comparing two values in two tables

kaushiknsolanki — Thu, 18 Aug 2016 11:12:08 GMT

Hi,

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

Regards,

Kaushik Solanki