Skip to Content
0

BPC 10.1 NW - CONVERSION FILE

Jun 21, 2017 at 08:21 PM

157

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Rekha Reddy Jun 23, 2017 at 03:18 PM
0

modified as below but still get an evaluation error

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jun 21, 2017 at 09:04 PM
0

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

Please read ANY online JavaScript manual!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jun 21, 2017 at 09:57 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jun 26, 2017 at 02:14 PM
0

*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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. Without SKIP the JavaScript will be:

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

JavaScript is a case sensitive language!

0