Skip to main content
Skip table of contents

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:


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.


Optional key fields to be excluded from the VARIANT output field. Default: Blank.

Configure the Make Var Record macro

  1. Select the Make Var Record icon, and then select the Configuration tab on the Properties pane.

  2. Optionally, select Justification and select the alignment of the VARIANT output field: Left, Right, or Data Specific.

  3. Optionally, select Key1 and select a key field to exclude from output. You may specify up to four keys.

  4. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.