PI mapping : particular value from a range of values and map it to a key.

[Former Member]

Hi Gurus,

  I am facing one issue in one of my mapping. I have the below requirement

Range : if source value is in b/w

1) 600000 to 609999  Use the key value as VAKR

2) 900000 to 909999 use the key value as DITR.

Please help me out to build a logic for the above in PI.

Regards

[Harish · Accepted solution]

Hi Veer,

you can achieve this either via standard graphical mapping function or via UDF.

Graphical mapping

input source field

input --> Grater then (600000) --> OR --> if

input --> Less then (609999) -->

then output VAKR

else

input --> greater then (900000)--> OR

input --> less then (909999) -->

if without else

map to DITR

regards,

Harish

[former_member190293 · Accepted solution]

Hi, Harish!

One thing: there must be AND instead of OR in your conditions.

Regards, Evgeniy.

[Harish · Accepted solution]

Thanks Evgenly. Yes there should be end

Updated logic

Graphical mapping

input source field

input --> Grater then (600000) --> AND--> if

input --> Less then (609999) -->

then output VAKR

else

input --> greater then (900000)--> AND

input --> less then (909999) -->

if without else

map to DITR

regards,

Harish

[Former Member]

Hi Veer,

As Harish said this can be achieved using graphical mapping