BPC 10.1 NW - CONVERSION FILE

[former_member623]

hello,

BPC 10.1NW ,EPM SP28 P3

i want to load values from 106002 :106007 (external data mapping) to PROD1 (internal). I tried below formula in "INTERNAL" column. but throws an error when i run DM pkg.

is there any syntax error in below formual?

js:If((parseint(%external%)>106001 AND parseint(%external%)<106008)?"PROD1":"*SKIP")

Thanks

Rekha

[former_member186338]

*SKIP can't be used inside JavaScript!

The simple way to achieve your goal is to use direct mapping without JavaScript:

0000106003 PROD1

0000106004 PROD1

0000106005 PROD1

0000106006 PROD1

0000106007 PROD1

* *skip

[former_member186338]

P.S. Without SKIP the JavaScript will be:

js:parseInt(%external%)>106001 && parseInt(%external%)<106008 ? "PROD1" : "NONE"

JavaScript is a case sensitive language!

[former_member623]

modified as below but still get an evaluation error

js:*if(%external% == "0000106003") "PROD1"

[former_member186338]

Where do you read about combination of "if" and ternary operator???? Why do you write "if"?????

[former_member186338]

"is there any syntax error in below formual?" - yes!

Please read ANY online JavaScript manual!