This topic has not yet been rated - Rate this topic

If-Then-Else Expression Example

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

If-Then-Else Expression Example

There is a Zip field in the input document and a State field in the output document. If the Zip is 98052 in the input document, then the State field in the output document will be updated with WA. If the Zip is not 98052, State will be updated with Other.

To do this, add an If-Then-Else Expression Map Operation to the Transform.

To do add a If-Then-Else Expression Map Operation

  1. Drag the If-Then-Else Expression to the Transform Designer surface.

  2. Create a link from the Zip field in the input document to this If-Then-Else Expression.

  3. Create a link from the State field in the output document to this If-Then-Else Expression.

  4. Configure the If-Then-Else Expression with the following parameters:

     

    Zip

    The input name will be displayed as the node name it is connected to in the input document.

    Zip

    Condition

    Zip == 98052

    Then Value

    “WA”

    Else Value

    “Other”

With this Transform, the State node in the output will be populated with WA if the zip code is 98052. If the zip code is not 98052, the State node will populated with Other.

Error and Data Handling

If an error occurs with an If-Then-Else Expression Map Operation, by default, the entire Transform is aborted. This error handling behavior is configurable. See Error and Data Handling at Expressions.

See Also

© 2013 Microsoft Corporation. All rights reserved.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
facebook page visit twitter rss feed newsletter