NAME:
LOAD * INLINE
[NAME
ALICE IN WANDERLAND
PPC NANYANG
#COTTON 65%
POLI925
ALICE IN HOME
PPC NANYANG
#COTTON 65%
POLI925];
KEY:
LOAD * INLINE
[KEY
ALICE
NANYANG
COTTON
RUBBER];
JOIN(NAME)
LOAD * RESIDENT KEY;
DROP TABLE KEY;
NOCONCATENATE
RESULT:
LOAD DISTINCT NAME, KEY WHERE FLAG > 0;
LOAD *, SubStringCount(NAME,KEY) AS FLAG
RESIDENT NAME
;
DROP TABLE NAME;