Want to convert Values in Mapping

[Former Member]

Hi All,

i want to convert Kilograms to Pounds, Cubic centimeters to Cubic Feet, Milli meters to Inches,

Please help me on this how can we do thin in Mapping

Regards

[Former Member · Accepted solution]

Hi Vamsi,

You can use fix values in mappping.

Or

You can use value mapping. See this blog on this:

/people/community.user/blog/2007/01/08/valuemapping-using-the-graphical-mapping-tool

Regards,

---Satish

[former_member750652]

Hi vamsi,

we can write UDF and convert the units to be mapped to target field. since these are all standards and not tend to change just like currency . UDF can help you out.

Thanks,

Ram.

[Former Member]

If you want to convert values from one unit to another, write three UDFs, one for each conversion.

Kilograms to Pounds,

Cubic centimeters to Cubic Feet,

Milli meters to Inches

and if you want to just convert the fields date from word "Kilograms" to "Pounds" and so on, then go for fixed value mapping or the value mapping.

Pooja

[Former Member]

Could u plz provide the UDF's please

[Former Member]

Hi Vamsi,

Actually these are simple conversions, and you can achieve them with the standard Arithmetic functions in the message mapping.

e.g to convert kg to pount you can use the MULTIPLY function and multiple the KG field with 2.20462262 to convert it into pound.

1 kilogram = 2.20462262 pounds

INPUT(in KG)..... 
                      multiply.........TARGET(pount)
Constant(2.20462262 )

For rest, I think you can easily google and find out the conversion rule. Its just simple multiplication and divison functions.

Pooja

[Former Member]

Hi.

you can use an value FixValue put the key(code) and the value of transformation for example.

FixValue

KEY..........Value

KG............1

PD............2.5

Field ........>FixValue----

---

>

Value--

---

>multiply--

---

>Target

[Former Member]

Could you please tel me the conversion value for Cubic Centemeters to Cubi Feet

Regards

[Former Member]

Vamsi,

Just google Cubic Centemeters to Cubi Feet, you will find the conversion rule.

Pooja