removing zero in conversion file

[former_member269849]

Hi experts ,

I'm trying to remove zeros in master data of a characteristic using the

js:parseInt(%external%) function.

but i'am getting the error duplicate ID and NaN.

here is my conversion file

what do you suggest ?

regards

[former_member186338 · Accepted solution]

What do you mean by this sentence:

"should I use external selection without the file selection ?"

I am talking about:

[former_member269849 · Accepted solution]

i wanted to say without the conversion file ?

[former_member186338 · Accepted solution]

Just to remove leading zero's you don't need to use conversion file! Why not to test yourself?

[former_member269849 · Accepted solution]

I tried to load with external format but i'm having this error

[former_member186338 · Accepted solution]

Sorry, but why do you think I can help without ANY information provided? No transformation file, no selection screenshots, no 0MATERIAL structure...

It looks like a joke - I have an ERROR, how to solve it?

In general try to limit selection only to few members and look on results...

[former_member269849 · Accepted solution]

Sorry Vadim.

here is the transformation file

my selection:

0material structure:

the error:

please if you need any additional information don't hesitate to mention it .

regards

[former_member186338 · Accepted solution]

Sorry, but the transformation file is strange...

Where is:

ID=ID

???

[former_member269849 · Accepted solution]

It can work without ID=ID i already did it if we don't have a compounding ID.

here is the validation of the ttransformation file :

with internal format:

validation with external format:

I've added ID=ID but it'snot working.

[former_member186338 · Accepted solution]

Try DELIMITER=TAB

[former_member269849 · Accepted solution]

Hi vadim,

it's not working even with with delimiter =TAB.

don't you find it strange that the file is successfully validated with internal format and and we have error with external format ?

PS:I tried the samething with another characteristic and it worked perfectly.

should I activate something on bW?

[former_member269849 · Accepted solution]

and when I tried it just for one value I put in selection ID=4000 .

the file is validated successfully , do you think that the problem is in some items and it's blocking the loading of all other values?

[former_member186338]

"and when I tried it just for one value I put in selection ID=4000 .

the file is validated successfully"

Then add more and test...at some point you will get an error - you will understand the reason.

[former_member269849]

Thank you Vadim for your help 😃

[former_member186338]

Sorry, but not clear what are you doing!

You are loading master data?

You are loading it from ...?

What do you want to achieve with parseint?

[former_member269849]

Hi Vadim,

I'm loading master data from BW to BPC .

Example:

000000000000001001 what i want to load to bpc 1001.

regards

[former_member186338]

To remove zero's use external selection when loading.

[former_member269849]

should I use external selection without the file selection ?