ALPHA conversion routine

[Former Member]

Hi All,

I'm having a problem with the ALPHA conversion routine. As far as I know, if you create a new InfoObject and you set the ALPHA routine, you should see leading zeros in the resulting value.

In my case, I have 2 InfoObjects that I want to concatenate in the new one. Let's say I have an InfoObject of 4 characters and the other of 8 characters. I created a new one of 12 characters now.

First, I didn't do it with the ALPHA routine, but then I read that it is necessary for the leading zeros that my client wants.

So I enmptied the InfoCube where it was being used, I also deleted the master data of the 12 characters InfoObject and went to the RSD1 to be able to add the ALPHA routine. For this, I had to change the InfoObject from NUMC to CHAR type, because not the ALPHA routine was not being taken into account.

I went to my transformation and tested the result of the concatenate, but it is still showing as in the example:

0011 + 02664575 = 1102664575

Is there something that I am forgetting to do? Any other way to have the leading zeros?

Thanks in advance,

Miriam

[Former Member · Accepted solution]

Hi,

If your 12 CHAR object is having ALPHA coversion then result will have 00s before values.

At transformation level you will not be able to see the same but in the end RESULT set it will be there as ALPHA runs after the RESULT is assigned. So just load the data and check.

I hope it will help.

Thanks,

S

[Former Member · Accepted solution]

Yes!! It worked as you said after re-loaded the data. Thank you very much.

Miriam