Make Var Record
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:
Justify | Justification of the fields included in the VARIANT output field: Left, Right, or Data Specific (left justify text fields, right justify numeric fields). Default: Data Specific. |
Key1...Key4 | Optional key fields to be excluded from the VARIANT output field. Default: Blank. |
Configure the Make Var Record macro
Select the Make Var Record icon, and then select the Configuration tab on the Properties pane.
Optionally, select Justification and select the alignment of the VARIANT output field: Left, Right, or Data Specific.
Optionally, select Key1 and select 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.