Select the Frames to fields option if your script produces Python list of dictionaries or a pandas DataFrame as the output. You can then map the data frame fields and types to PDI fields and types when running the transformation.
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. If necessary, you can modify your selections.
Option | Description |
---|---|
Data structure field | The value of the Python data structure field which you want to map to the PDI field. |
Data structure type | The value of the data structure type assigned to the data structure field which you want to map to the PDI field. 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 data structure field. |
PDI data type | The value of the data type assigned to the PDI field, such as a date, a number, or a timestamp. |