While match name

penpayom — Wed, 21 Sep 2022 17:07:35 GMT

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

but I not used if Loop because Variety key

please help me

Re: While match name

Chernov — Fri, 22 Feb 2019 02:52:38 GMT

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;

article While match name in Member Articles

While match name

Re: While match name