AO Max ID
Overview
AO Max ID accepts a single stream with a numeric ID field as input. It scans that field to find the maximum ID value and appends the maximum value to all records for use in AO Constant Key and AO Constant Key Advanced.
This macro requires the processing and temporary storage of every record in the stream. If you have records in a database, it is better to query the database for the maximum ID using an SQL statement like SELECT COALESCE(MAX(ID),0).
AO Max ID configuration parameters
AO Max ID has a single set of configuration parameters:
Input
Parameter | Definition |
|---|---|
ID | (Required) The ID field to scan.
|
Output
Parameter | Definition |
|---|---|
Maximum ID | (Required) The field to receive the computed maximum ID value.
|
Configure AO Max ID
To configure AO Max ID:
Select the AO Max ID icon.
Go to the Configuration tab on the Properties pane.
Select ID and choose the field containing the numeric ID field.
Optionally, select Maximum ID and edit the field name for the output ID.
Optionally, go to the Execution tab, and then set Web service options.