topic Re: Flag field based on string data in multiple fields in QlikView

Flag field based on string data in multiple fields

surajap123 — Tue, 15 Feb 2022 12:31:09 GMT

Hi There,

I want to create a new flag field whenever the term below terms are found in Name or Desc columns.

CD or Disc or CD Disc

ID	Name	Desc	Pos
6957	GBC Poly Designer Binding Covers	Office Supplies Disc	OFF-BI-10000320
6958	HTC One Mini	Technology	OFF-AR-10004999
6959	Laser & Ink Jet Business Envelopes	Office Supplies Disc	OFF-BI-10001116
6960	Cardinal Holdit Data CD Disc Pockets	Office Supplies	OFF-AP-10002651
6961	HTC One Mini CD	Furniture	OFF-AP-10001634

Please suggest.

Thanks

Marijn — Tue, 15 Feb 2022 12:37:35 GMT

You can use substringcount:

if(SubStringCount(Name&Desc, CD) >0 or SubStringCount(Name&Desc,Disc) >0, 1, 0) as Flag

surajap123 — Tue, 15 Feb 2022 13:56:40 GMT

Thank you so much @Marijn

Marijn — Tue, 15 Feb 2022 13:58:51 GMT

You're welcome @surajap123 !