Variable to fields processing

Select the Variable to fields option if your script is intended to produce its output in the form of individual variables, each of which contains a built-in type, such numerics, strings, and Booleans. This option will map the Python variables and their data types to PDI fields and their data types when running the transformation.

Output tab in Python Executor

These are the fields in the Mapping table. Select the Get fields button to populate the table with fields from the output step(s) in your transformation.

Note: The Get fields button will execute your Python script using random input values to determine the output variables. If your script is long running, or has fixed data requirements, consider manually entering the output variable mapping.

Option	Description
Variable	The name of the Python variable that will be mapped to a PDI field.
Python data type	The value of the data type of the variable. For detailed information on data types, see Mapping data types from Python to PDI.
PDI field	The value of the PDI field to which you want to map the Python variable.
PDI data type	The value of the data type assigned to the PDI field, such as a date, a number, or a timestamp.