Hi
Just to make sure I understand, you want to update the lookup in WF, so that, for instance your first line Fracture is BB, in CXP, line 2 (ID_CONCAT) = BB, so that it points to the correct record in CXP.
Just want to make sure thats accurate.
As a very simple walkthrough (and its simple due to needing my information) and questions
1. Is this a 1 time activity, where you have 2 tables and you want to go through and Link the LookUp records and then going forward it will be set with some built I process or are you looking for just a "how would I do this" type thing?
It sounds more like a Manual (trigger it once kind of thing).
So a question
1. What type of field is ID_CONCAT a string? and is FRACTURE a string data type as well?
Ok now let's give you one way to do it, that is a 1 time run. You could do it more than once, but this is primarily a way to set the lookups if its a new table initially not something to run all the time.
Then in the future, you could setup a Flow, so that anytime a record is created in WF, it would automatically attempt to find and attribute the COD lookup which I can show you as well... OK brb then Ill walk through it.
