Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sdepotter
Contributor
Contributor

Check if value exists in other table

Hi

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

4 Replies
el_aprendiz111
Specialist
Specialist

Hi,

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

Sergey_Shuklin
Specialist
Specialist

Hello, Samuel!

Did you use an inner join operator?

vishsaggi
Champion III
Champion III

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.

Anonymous
Not applicable

Try

ExcelFile1:

Load

FieldA as Field2

from

ExcelFile1;

noconcatenate

ExcelFile2:

Load

Field2

from ExcelFile2

where exists(Field2);

Drop Table ExceilFile1;