Check if value exists in other table

[sdepotter]

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

[el_aprendiz111]

Hi,

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

[Sergey_Shuklin]

Hello, Samuel!

Did you use an inner join operator?

[vishsaggi]

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]

Try

ExcelFile1:

Load

FieldA as Field2

from

ExcelFile1;

noconcatenate

ExcelFile2:

Load

Field2

from ExcelFile2

where exists(Field2);

Drop Table ExceilFile1;