Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to replace field values of dimensions in the data manager. For example I have the following field values: USA, US and United States, while i want them all to be named USA. This should be possible in the replace tab. However this is only possible when a table has 100 or less distinct values, while my table has 2800 distinct values.
Is there a way to solve this?
Regards,
Pascal
Hello Pascal,
I would use a mapping loads to do this.
Please find the attached, hope it meets you requirement.
Thanks
Vamsee
Note: Instead of the inline table you can use an excel if the data set is huge