I need to add a calculated field in my script.
This field is calculated from three table, the field that I have to add is Shadowlocal:
if agentName= CountryLocalShadowRouter
then ShadowLocal= True
else ShadowLocal= false
the field "agentNmae" is from the table Data and the field CountryLocalShadowRouter is from the table Countries.
This is my DataModel:
I have to use a mapping to calculate this field but I don't know how! I need your help please!