Qlik Community

QlikView Documents

Documents for QlikView related information.

While match name

penpayom
New Contributor

While match name

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

but I not used if Loop  because Variety key

please help me

W.PNG

Attachments
Comments
schernov
New Contributor III

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;

 

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎12-20-2018 12:17 AM
Updated by:
 
Contributors