Looking to use Regex in Value Mapper
We have a column with the following example string:
holiday home insurance_E
We need to search for any string with the _E at the end and update a Match Type column using Value Mapper with 'Exact'
We have tried using RegEx ^[\w|\s]+_E$ which correctly identifies the string but the value mapper is not updating the column or recognising the value.
Any thoughts on how we can accomplish this?