Reltio Connect

Hi Experts,

in RDM  country lookup ,we have standard 249 values for different countries and each country having multiple source system values mapped to its canonical value.Now by OOTB mode ,we have two letters code set as canonical value for all but we want to change the canonical value to three letters code for all countries which is also present in one of source system mappings for each country .

Could you please let me know how to do change this quickly for all the entries in country lookup without the manual work of changing that one by one ?

There are some ROCS utilities 

You can use them to Extract , modify in bulk and import.

https://bitbucket.org/reltio-ondemand/util-rdm-dataextract/src/master/

https://bitbucket.org/reltio-ondemand/util-rdm-dataloader/src/master/

Again this is not an end to end straight forward solution, but better than fully manual effort.