Hi, is it possible to map variation values? For example:
CSV contains various 'Colour' values such as 'blck' 'blk' black' 'BLACK' 'Red' 'Rd' 'Gold' 'Gld'
Is it possible to map these values so that 'blck' 'blk' 'black' 'BLACK' all get imported as 'Black' and the same for Red and Gold e.g. 'Rd' gets imported as 'Red', or is there any way of assigning/mapping these values to the correct feature?
I thought about using modifiers but my understanding is that you can only use 1 modifier per field so I could use the 'replace' modifier but it would only search and replace one of the above values.
Any suggestions welcome, thanks!