Select the Row by row option to process your data row by row. Each input row will have its fields mapped to the variables as defined in the Mapping table, below. Your Python script will be executed once for each incoming row.
CAUTION:
When using the PDI Engine, you can include multiple input steps of the same schema. Each
input step must have the same field structure, such that fields and types must appear in
the same order in each incoming step. If you include multiple input steps of different
schema, an error will occur.
The Mapping table contains the following field properties.
| Field Property | Description |
|---|---|
| Variable | String assigned as a Python variable. |
| Python data type | The Python data type assigned to the variable, such as a string (‘str’), an integer (‘int’), or a floating point (‘float’). For detailed information on data types, see Mapping data types from PDI to Python. |
| PDI field | The PDI field to which you want to map the Python variable. |
| PDI data type | The data type assigned to the PDI field, such as a date, a number, or a timestamp. |
Select the Get fields button to populate the table with fields from the input step(s) in your transformation. If necessary, you can modify your selections.