Link two fields

[New-here1]

Hello experts, 

Please could you help me; I need to link/join two fields together - Country_Number with World_Reference_Number

What is the best way to do this in the script please?

Thank you

[rwunderlich]

Fields will link only when they have exactly the same name and values. So rename one of the fields when loading.

Load 
World_Reference_Number as Country_Number, ...

-Rob

[New-here1]

Hi Rob, 

I have done that but it doesn't seem to be working; the sheet showing Country_Number  is only showing  data for that, and the other sheets that reference World_Reference_Number is only showing data for that. When I did the change you requested, other fields were missing data. Am I doing something wrong?

[rwunderlich]

Can you post a screenshot of your data model from the data Model Viewer?

-Rob

[New-here1 · Accepted solution]

Hi Rob, I managed to get it to work. Thank you for your help