HiI want to keep the data as it for in Sector column for Location which has :-ABCCATBTRin their location name and forMATI want to change it to false. In excel we can achieve this by MID formula. But how to get it done in Alteryx?
@sgaryali one way of doing this
regex formula can do it fairly well
REGEX_Match([Location Name], ".*ABC.*||.*CAT.*||.*BTR.*")
