I have a source file with fields customer and country .Currently a,b,c customers are marked as Germany customers,and other customers say d,e,f...belong to Germany or different countries.
Now the requirement is to implement a generic solution to change it to Austria customers without hard coding in script.
What i have tried:
MAP:
MAPPING LOAD Country,
newCountry
from mappingfile;(created one)
Datamodel:
ApplyMap('MAP',"E") AS [Customer Country] ,
Result:
Now a,b,c customers are mapped to new country but other customers say z which is having Germany as country will also be mapped to Austria. Hence how to apply condition(if any other) here?Can anyone help here?
