Range Profile Macros are commands that will be processed through pasFusion to determine a specific value for the desired field in which they are used.

 

The pasTransfer integration in pasFusion supports 3 different macro commands:

 

•[RangeDefinition|ColumnName] - This macro will enable the use of the pre-defined range columns within the range profile manager.  If a column exists named Amount, the macro [RangeDefinition|Amount] will return the value of the amount column for each row processed.

 

•[Range|Range] - This macro will enable the use of a range of cells outside the pre-defined range.  It is required that this range is the same amount of rows as all other pre-defined columns.  [Range|$B1:$B10] will process each row in the B column from 1 to 10, granted that the initial source range contained 10 rows.  The range macro must be a single-column range.

 

•[Cell|Cell] - This macro enables the use of a single cell as a recursive value for each row processed.  If a transaction date is specified in cell $T28 that is used for all of the rows to be processed, the macro [Cell|$T28] will return the value of that cell for every row processed.

 

Failure to follow this criteria on the use of macro-commands will result in a failure of processing the source data, or incorrect data entered.

 

Copyright © 2024 pasUnity, Inc.

 

Send comments on this topic.