Make Var Record
Overview
The Make Var Record macro packs all input fields except defined keys into a single string value called VARIANT. The VARIANT field contains all fields concatenated, with each field justified inline according to the specified option (Left, Right, Data Specific). You may optionally select up to four key fields to be excluded from the final VARIANT field.
This macro is especially useful for creating "variant record" or "transaction" files.
Make Var Record macro configuration parameters
The Make Var Record macro has a single set of configuration parameters.
Parameter | Description |
|---|---|
Justify | Justification of the fields included in the VARIANT output field: Left, Right, or Data Specific (left justify text fields, right justify numeric fields).
|
Key1...Key4 | Optional key fields to be excluded from the VARIANT output field.
|
Configure the Make Var Record macro
Select the Make Var Record icon.
Go to the Configuration tab on the Properties pane.
Optionally, select Justification and choose the alignment of the VARIANT output field: Left, Right, or Data Specific.
Optionally, select Key1 and choose a key field to exclude from output. You may specify up to four keys.
Optionally, go to the Execution tab, and then set Web service options.