topic Re: Check if value exists in other table in QlikView

Check if value exists in other table

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

have been trying to solve this issue for days and it's driving me crazy

We have 2 data sources (excel files) in our script and would like to compare field A (from 1st Excel) with field 2 (from 2nd Excel file). Overall objective is to identify only those values that are present in both fields (in 2 different files). we don't want to create key between the two fields becaise the data files are very large and this would really slow down the Reload

Would this even be possible?

Much appreciated,

Sam

Re: Check if value exists in other table

el_aprendiz111 — Thu, 11 May 2017 17:10:24 GMT

Hi,

lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])

Re: Check if value exists in other table

Sergey_Shuklin — Thu, 11 May 2017 17:59:06 GMT

Hello, Samuel!

Did you use an inner join operator?

Re: Check if value exists in other table

vishsaggi — Thu, 11 May 2017 20:37:16 GMT

I know you have many rows, however if you use Inner Join as suggested by Sergey, it should solve your problem. However, if you can create some sample rows from both the tables and expected output, it would be easy to work on quickly.

Re: Check if value exists in other table

Anonymous — Thu, 11 May 2017 21:18:42 GMT

Try

ExcelFile1:

Load

FieldA as Field2

from

ExcelFile1;

noconcatenate

ExcelFile2:

Load

Field2

from ExcelFile2

where exists(Field2);

Drop Table ExceilFile1;