MappingLine

 

Description

Extracts the value of a dynamic attribute from a destination mapping line.

 

Arguments

1.MappingLine- Name of the Macro.

2.Name - The mapping line custom attribute to be copied.  This value is case sensitive.

3.Default Value - The value to be used if the attribute cannot be found or is blank.

4.Search Value - If the returned value matches the search value, the specified default will be returned. The search value and returned value will use casing to determine a match.

 

Examples

[MappingLine|Entity]

If [MappingLine|Entity] is available this will return the [MappingLine|Entity] value.

If [MappingLine|Entity] is not available this will return a blank value.

 

[MappingLine|Department|101]

          If [MappingLine|Department] is available this will return the [MappingLine|Department] value.

If [MappingLine|Department] is not available this will return the value "101".

 

[MappingLine|Department|999|401]

          If [MappingLine|Department] is available and does not equal 401 this will return the [MappingLine|Department] value.

          If [MappingLine|Department] is available and equals 401 this will return the value "999".

If [MappingLine|Department] is not available this will return the value "999".

 

Notes

This macro is only available for use in the context of destination output processing and is not available until after mapping lines have been generated by the engine.  Available attributes are specific to each destination and some destinations may not have any attributes at all. Please consult the destination documentation or pasTransfer for information on which attributes are available.  If a case-insensitive comparison is desired between the search value and the returned value use an If macro combined with a Lower or Upper macro.

 

Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.