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.