Hi there - trying to get foreach statement to apply conditional statement. Essentialy in the eval statement tried a variety of if with options like IN statements (or alternatively but less preferably a long OR to replace the IN statement )- but frankly not having any luck.
foreach Perc_In* [ eval Out_Of_Norm_For<<MATCHSTR>>=if(IN(<<MATCHSTR>>,"_Range_4","_RANGE_4_to_6"),"Consider","Ignore") ]
If the <<matchstr>> falls in the set of values "_Range_4" or "_RANGE_4to_6", then the new field Out_Of_Norm_For<<MATCHSTR>> should take a value of consider - else it takes a value of Ignore
... View more