How to use mapping function for certain customers

Anonymous — Mon, 10 Dec 2018 16:35:45 GMT

Hi,

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?

Re: How to use mapping function for certain customers

sunny_talwar — Mon, 10 Dec 2018 17:10:50 GMT

May be something like this

If(Match(Customer, 'a', 'b', 'c'), ApplyMap('MAP',"E"), "E") AS [Customer Country]

topic How to use mapping function for certain customers in App Development

How to use mapping function for certain customers

Re: How to use mapping function for certain customers