cancel
Showing results for 
Search instead for 
Did you mean: 

mapping using boolian values

former_member185856
Participant
0 Kudos

Hi,

I am facing the problem to map the following condition can anyone help.!!!!

source: target

Zip - Integer

State - String State - string

I want to map these things using logical mapping.....

reqmt: When the ZIP = 100 and State = karnataka then target side State should get the value as "Karnataka" is it possible to Map these type??

Thx in Adv,

Sunil K Shetty

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Sunil,

You can use the following logic in message mapping in graphical mapping editor.

/ns0:Trg_Student_MT=/ns0:Src_Person_MT= /ns0:Trg_Student_MT/Name=ifWithoutElse(and(equals(/ns0:Src_Person_MT/ID=, const()), equals(/ns0:Src_Person_MT/Name=, const())), /ns0:Src_Person_MT/Name=)

For ur scenario plz replace ID with Zip and Name with State.

Hope it helps.

Regards,

Latika Sethi.

former_member189418
Participant
0 Kudos

Hi Suni,

U can use FixValues in the Conversions category.

in that give key as 100 and value as Karnataka. u will get the required output.

Anil

former_member185856
Participant
0 Kudos

Hi Anil,

I used Fix value function.... thnsx.. a lot...we can do many thngs using Fix values....

Thnx a lot for providng rig8 answer..

Thanks a lot,

Sunil K Shetty

Former Member
0 Kudos

Hi Yes you can do it

Try out this mapping

ZIP <b>Equals</b> Constant("100") <b>and</b> State <b>Equals</b> Constant ("Karnataka") IF Then Constant("Karnataka") --- Target Field

Mudit

Award Points if it helps

Former Member
0 Kudos

Hi Sunil,

Use If-then-else GUI functionality with a constant in your mapping to achieve this.

cheers,

Prashanth

P.S Please mark helpful answers

Former Member
0 Kudos

Hi

Use

standard GUI mapping function ,"if"(boolean) and a "constant" to do the mapping

Regards

krishna