Skip to Content
0
Former Member
Nov 05, 2012 at 02:45 PM

Graphical Mapping Query

27 Views

Hi,

Been using PI for a couple of years but I have rarely had a need to use the functions available at mapping time. I have an example where the following mapping (transformation) is required:

OutboundValue: "H"

Inbound Value: "-"

Outbound Value: "S"

Inbound Value: "+"

(H and S are the only 2 possible values)

i.e. if Outbound Value = "H" then Inbound Value = "-" Else Inbound Value = "+"

I have managed to achieve this using ReplaceString as follows:

This works as it does a ReplaceString of "H" with "-" followed by another of "S" with "+". Even though this works my feeling there must be a way involving Boolean functions i.e. If Then Else etc.

Is there another way to achieve the same result as I have managed without using a double pass of the ReplaceString function ?

Cheers,

PaulC.

Attachments

gmap1.JPG (25.2 kB)