Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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!
Thank you
Create a mapping table Country_Mapping with Fields
Tab:
Mapping
LOAD * INLINE [
CountryLocalShadowRouter, ShadowLocal
All values of this field, True
];
Then write this in your script within Data table
Applymap('Tab',agentName,'False') as Something
Create a mapping table Country_Mapping with Fields
Tab:
Mapping
LOAD * INLINE [
CountryLocalShadowRouter, ShadowLocal
All values of this field, True
];
Then write this in your script within Data table
Applymap('Tab',agentName,'False') as Something