cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping other than using FixValues

Former Member
0 Kudos

Hi all,

If 'a' is W or D, then assign XYZ.D

If 'a' is G or GP, then assign XYZ.BGI.G

for all other values, assign INDEPENDENT

Is there any efficient way to do this, I have used the function FixValues.

But I don't want to use this approach is there any dynamic selection approach or an UDF for this logic.

--

Srini

Accepted Solutions (1)

Accepted Solutions (1)

former_member181962
Active Contributor
0 Kudos

Hi Srinivas,

The FixValues function is tailor made for your requierement.

One alternative would be to use the IF condtions in the graphical mapping tool, but i don't think it is better in anyway.

Regards,

Ravi Kanth Talagana

Former Member
0 Kudos

Ravi,

But I have to assign values for INDEPENDENT , there are nearly 50. I just want to eliminate that process of entering, in future there are any additions I don't want to keep on adding the values.

Thats why I need a dynamic approach.

--

Srini

former_member181962
Active Contributor
0 Kudos

No Srinivas,

In Fix values, you can just specify a Default value for all others.

there will be an option for Default, specify the value as 'INDEPENDENT'.

Regards,

ravi

Former Member
0 Kudos

Ravi,

Oh ya thanks for the quick rply.

--

Srini

Former Member
0 Kudos

Ravi,

But can we write a UDF for this?

--

Srini

Answers (0)