MappingLine

 

 

 

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.

5.Output Format - A .NET format string used to transform the decimal or date value using number and date formats from the contextual culture settings.

 

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".

 

[MappingLine|DestinationAmount|||#,000.00#;(#,000.00#)]

          If [MappingLine|DestinationAmount] is a positive value of 1000.00 , a value of value of 1,000.00 is returned.

          If [MappingLine|DestinationAmount] is a negative value of 1000.00 , a value of value of (1,000.00) is returned.

          If [MappingLine|DestinationAmount] is a positive value of 1000.005 , a value of value of 1,000.005 is returned.

          If [MappingLine|DestinationAmount] is a positive value of 1000.005 , a value of value of (1,000.005) is returned.

 

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 © 2023 pasUNITY, Inc.

 

Send comments on this topic.