RECODE

[Anonymous]

hi guys,

Please help with idea how to recode all remaining tags to one tag

IF(wildmatch([AAA],'*support*'),'Came for support',IF(WildMatch([Primary purpose of visit], not '*support*'),'Others') ) as [Primary purpose of visit],

Thanks,

[alexandros17]

IF(wildmatch([Primary purpose of visit],'*support*')>0,'Came for support','Others')

) as [Primary purpose of visit],

[its_anandrjs · Accepted solution]

Try this way

IF(Wildmatch([AAA],'*support*'),'Came for support',

IF(Not WildMatch([Primary purpose of visit],  '*support*'),'Others') ) as [Primary purpose of visit]