I have a library containing a large amount of items.
The library contains a column of type 'Single line of text' with a code in it. The code was taken from an external system and entered manually.
There is a now a library on the SharePoint site itself containing all the codes. I need to change the library column containing the codes to type 'Lookup' referencing the new SharePoint library containing the codes.
I know this cannot be done directly.
I need a way to take the value from old code column and use it to set the new lookup column referencing the code in an external library.
I really have no idea about how to go about this.
Has anyone encountered a similar problem and hence be able to offer me some advice about how to go about this? The library have over 15,000 items, so doing this manually would be out of the question.