on 05-23-2007 11:08 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Use
standard GUI mapping function ,"if"(boolean) and a "constant" to do the mapping
Regards
krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.