Error:*IF() statement in transformation file

[karan_kothari2]

Hi Everyone,

I am using IF statement in Account transformation file.

Requirement:

Needs to update the ACCTYPE property through DMP. which is as follows:

Accounts starting with 001= "AST"

Accounts starting with 002= "LEQ"

Accounts starting with 003= "EXP"

Accounts starting with 004= "INC"

In transformation, i have scripted it as below:

*IF(ID(1:3)=*STR(001) THEN *STR(AST);*IF(ID(1:3)=*STR(002) THEN *STR(LEQ);*IF(ID(1:3)=*STR(003) THEN *STR(EXP);*STR(INC))

It is giving me the following error:

Please correct me for the IF statement.

[Former Member · Accepted solution]

Hi Karan,

Use below post as reference and remove multiple IF just write only first IF....

BPC Transformations - IF Condition | SCN

Something like....

*IF(ID(1:3)=*STR(001) THEN *STR(AST);ID(1:3)=*STR(002) THEN *STR(LEQ);ID(1:3)=*STR(003) THEN *STR(EXP);*STR(INC))

Regards,

JP

[karan_kothari2 · Accepted solution]

It's working now...!!

Thank you JP..!!