*IF statement under Mapping section of transformation file

[Former Member]

I am trying to write the following statement but get error, this is transformation file for loading account master data

*MAPPING

ID=*IF(ID(1:2)=*STR(AA) /*STR(BB) THEN ID;*STR(A_) + ID))

Basically, if the account number is start with AA or BB, then the account number in BPC will be A plus the account number in BW.

How can we archive this logic here.

Thanks,

[Former Member · Accepted solution]

Hi Jian,

Plese try the following:

ID=*IF(ID(1:2)=*STR(AA) then  *STR(A_)+ID;ID(1:2)=*STR(BB) then  *STR(A_)+ID)

You have not mentioned what if the ID does not start with AA or BB, if you take only ID in that case just do the following:

ID=*IF(ID(1:2)=*STR(AA) than  *STR(A_)+ID;ID(1:2)=*STR(BB) than  *STR(A_)+ID;ID)

Regards,

Kalyan.