on 06-25-2009 10:25 AM
Hi Experts,
I am using value mapping,i have 4 source fields A,B,C,D and I need to get 1,2,3 for A,B,C and SPACE for my last field in Target side.How can i get this.
Thanks.
Hi,
Fixed values would suffice your requirement as the table is quite simple. A on the other hand you cannot have space as a value in value mapping tables. However, if you want to create a a value mapping table, then create the group with Source and Target schemas and only set values for A, B & C. Default a space if there is no value found ( input & output is same ) after value mapping is executed . This say you can easily extend the value mapping table further without having to go to the mapping program. For example tomorrow you can have value sets A, B, C , E, F mapped to 1, 2, 3,4, 5 and so on.
regards,
Advait
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For basic value mapping you should probably use FixValues function, if by some reason you need a table values (different rules conversion for different partners/customers for example) then you should apply a value mapping table
your example sounds like fair enough for a simple fixvalue function (A=1, B=2, and so on) you can even use a default value if required
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
>If you want to achieve this using Value Mapping you need to maintain the Value Mapping table in ID,From Menu>Tools-->Value Mapping.
In this table:
A -
> 1
B -
> 2
C -
> 3
D -
> SPACE(Just leave as Blank) .
-->If you want to use the fixed values we can maintain at Message Mapping level it self.
>For source field->value Mapping-->Target field. You need to follow this for each and every source field to target filed.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
in Fixvalue
A = 1
B = 2
C = 3
D = PRESS SPACE BAR
rgds
srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
You can use in your mapping, the function "Fixvalues"(conversions)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.