topic Re: Comparing two column values in QlikView

Comparing two column values

Thu, 09 Apr 2015 11:50:53 GMT

Hi All,

I have to compare the values present in two columns. But the columns are located in different tables. e.g. I have to compare values of Column A with the values of Column B. Column A is present in Table A whereas Column B is present in table B. How do I compare them in the script?

Re: Comparing two column values

robert_mika — Thu, 09 Apr 2015 12:02:07 GMT

Do you have only one field per table?

Do they have any common column?

What's is expected result?

Yes/NO or values that exist in one column only?

Re: Comparing two column values

Thu, 09 Apr 2015 12:07:02 GMT

Both the tables have multiple columns.

They have a common column.

The expected output should be Yes/No based on the match found.

Re: Comparing two column values

Anonymous — Thu, 09 Apr 2015 14:22:17 GMT

I think you should use exists() function if you want to do this in the script.

Re: Comparing two column values

robert_mika — Thu, 09 Apr 2015 14:39:10 GMT

Could you post sample of data?

Re: Comparing two column values

Gabriel — Thu, 09 Apr 2015 14:51:14 GMT

Hi,

I think you can bring both field into a temp table, from there you can then use IF statement to check field value and create a YES/NO field. Finally left join or ApplyMap the new field back to any of the tables.

Re: Comparing two column values

robert_mika — Thu, 09 Apr 2015 15:16:55 GMT

T1:

LOAD Num AS Num,

Boom as Boom1

FROM

COMAPRE.xlsx

(ooxml, embedded labels, table is Sheet1);

temp:

LOAD Num as Num,

lookup('Boom1','Num',Num,'T1') as Boom1,

Boom as Boom2

FROM

COMAPRE.xlsx

(ooxml, embedded labels, table is Sheet2);

final:

load Num,

Boom1,

Boom2,

If(Boom1=Boom2,'Yes','No') as Compare

Resident temp;

drop table T1,temp

Re: Comparing two column values

beck_bakytbek — Thu, 20 Apr 2017 22:17:28 GMT

Cool Stuff, very useful and powerful

Thanks a lot

Beck