hope I got your issue correctly. Please see attached example. I haven't used match function, but simple counts after building a common concatenated table.
(I don't really need the links to the other tables, we can get rid of the links by simple renaming the table3 fields and expression in straight table, if needed.
CitiesMatch.qvw 153.2 K
Sure, you could use similar expressions as in the straight table to create new fields in the script.
See attached sample.
Is this like you want it?
CitiesMatch2.qvw 157.5 K
This is the script code:
(html, codepage is 1252, embedded labels, table is @1);
(html, codepage is 1252, embedded labels, table is @2);
LOAD CitiesList as AllCities,CitiesList
Concatenate Load Cities as AllCities, Cities
if(count(Cities) and count(CitiesList),'Y','N') as InCities,
if(count(CitiesList)=0 and count(Cities),'Y','N') as NewInCities
resident table3 group by AllCities;