Value map issues

[Former Member]

I have seen Value map posts and blogs with this scenario of data:

Source Target

1..............A

2.............B

3.............C

4.............D

But i want to have some thing like this:

Source Target

1...............A

2...............B

3...............B

4...............A

As it seems its not possbile in Value mapping but i tried to relate this with Group Name but there is no way to access group name in IR Any inputs?

[Former Member]

it is possible with FixValues

Instead of value mapping use FixValues

[Former Member]

Fixed values cant be an option as this has to be created for every map which is not a great design.i figured out a way out thanks for ur inputs.

[Former Member]

Hi,

Check this link for Value mapping.

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

Regards,

phani

[Former Member]

Hi,

Write an UDF:

What you do is

IF(input value is 2=2 or input value is 3=3)

{

pass output as required.

}

IF(input value is 1= 1 or input value is 4=4)

{

pass output as required.

}

Thanks and Regards,

Chirag Gohil