Skip to Content

How to remove leading zeros using conversion file

Hi Team,

While loading data from BW to BPC i want to remove leading zeros of project master data.

for this i tried using following java script code in conversion file but i am getting following error

EXTERNAL INTERNAL

  • js:PARSEINT(%external%)

Error :Detected duplicate member ID 'NaN

Please help.

Thanks,

SK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 14, 2017 at 10:09 PM

    Looks like you have not numeric ID's - NaN - Not a Number!

    What format are you using?

    External or Internal format? External will remove the preceding 0

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 02:50 PM

    Thanks Vadim It worked .

    By choosing external format in DM package it removed preceeding zeros.

    Add comment
    10|10000 characters needed characters exceeded