cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove leading zeros using conversion file

former_member250987
Participant
0 Kudos

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

Former Member
0 Kudos

Are you trying to load master data or transaction data?

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

former_member250987
Participant
0 Kudos

Thanks Vadim It worked .

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