check for certain value in field

[markgraham123]

Hi all,

I'm trying to create a flag if ID has 0102 or 0607 in its name. Can someone please help?

ID, Name

1,   0102,0304,0102, 0909

2,  0102,0607

[julian_rodriguez]

Hello Mark

Please see the MapSubstring function, pherhaps can be useful for your need

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/MapSu...

Regards