on 08-06-2010 2:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.