apply map

[upaliwije]

Hi Friends

I have written following script in my data load

But it does give any results for 2nd apply map condition. Have I made any error . Pls help me to get it correct

[Peter_Cammaert · Accepted solution]

Your logic is wrong. I'd like to add some spaces to your statement:but you posted a screenshot and that's difficult to edit...

The second ApplyMap() call is only executed when CRE_TYPE='2', but this test is embedded as third parameter in the first ApplyMap() call that is only executed when CRE_TYPE='1'. The third parameter of an ApplyMap() call is only executed if the second parameter cannot be found in the Mapping Table as specified by the first parameter.

CRE_TYPE cannot have two values at the same time.

I guess you better write someting like:

IF (CRE_TYPE='1', ApplyMap('map1C', ..., Null()),

                  IF (CRE_TYPE='2', ApplyMap('map2C', ..., Null()))) AS CP_RATE

[upaliwije]

Thanks a lot