different (and wrong) resultsets in lookup depending to the number of columns

Program: Advanced ETL Processor Enterprise.
Version: 5.6.2.9
OS: Windows 2008 R2
DB: MySQL 5.5.27

Hi there

To find out changes in reader list (Excel), I do during the validation a lookup in the mastesr table (mysql).
If the record is not found I set as return value 'unknown'.
With 'is equal to' = 'unknown' --> false, I discard unmodified records.


A lookup with 1 column returns 16 modified records, which is correct (in attached example: code)
A lookup with 2 columns returns 17 modified records, which is wrong (in attached example: code, en)
A lookup with 3 columns returns 18 modified records, which is wrong (in attached example: code, en, fr)

Attached is the master table, the reader table and the validation printscreen.

Thanks, Lionel

Looking at it now

Mike

Can you try latest version please.

Mike

still wrong results, but now:
- 1 column (code) --> 16 results (correct)
- 2 columns (code, en) --> 18 results
- 3 columns (code, en, fr) --> 17 results

if you need: you already have the repository backup from the other support case. --> Project: Mitarbeiter-Stammdaten, Transformation: temp&drafts/falseResults

Lionel

An update

I did some more testing and I can see that the diffrence is related to this value
BA Bosnia and Herzegovina Bosnie-Herzégovine , la Bosnie-et-Herzégovine

I am still looking at it and hope to give you another update later

Peter

it is not only this value. Depeding on the number of lookup columns:
MO Macao S.A.R., China Macao Macao
HK Hong Kong S.A.R., China Hongkong Hong Kong

It looks like that commas are not welcome....

Lionel