Hi I have two tables which are both Sharepoint List
I am trying to find a solution to add the ID number from the master_list to the profile_list
the master_list countains unique accounts , and the profile_list contains multiple rows of data linked to the master_list by code.
example master_list
ID Code Name
01 DD Daves Dodgems
02 FF Fred's Fries
master_profiles
Code Region Owner
DD EUR Bob
DD NOA Alan
FF EUR Steve
FF MDE Brian
FF NOA Rachel
I need to loop through all the rows in the master list and where the code is matched in the master_profiles list add the master_list ID to the matched master_profiles , so it would like this
master_profiles fixed
Code Region Owner AccountID
DD EUR Bob 1
DD NOA Alan 1
FF EUR Steve 2
FF MDE Brian 2
FF NOA Rachel 2
Is this possible ???
