Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try this way
IF(Wildmatch([AAA],'*support*'),'Came for support',
IF(Not WildMatch([Primary purpose of visit], '*support*'),'Others') ) as [Primary purpose of visit]
IF(wildmatch([Primary purpose of visit],'*support*')>0,'Came for support','Others')
) as [Primary purpose of visit],
Try this way
IF(Wildmatch([AAA],'*support*'),'Came for support',
IF(Not WildMatch([Primary purpose of visit], '*support*'),'Others') ) as [Primary purpose of visit]