While match name

[penpayom]

I Want  to  find and Replace  keyword from "KEY" in Column Result 

but I not used if Loop  because Variety key

please help me

[Chernov]

Hi, try this script: 

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;