You can specify a PowerHouse portable subfile as the data source for a model.
Dictionary component | Model equivalent |
Element name | Column original name |
Element heading | Column name; the PDL multiline character (^) is replaced by a space character |
Item datatype - character | Data class text and size |
Datatype - portable zoned | Data class: unspecified (default); Measure type: 32-bit integer |
Datatype - portable float | Data class: unspecified (default); Measure type: 64-bit floating point |
Datatype - portable date | Data class: date; date input format: predefined |
Instead of using the PowerHouse dictionary values to set the Output scale and Precision properties, columns generated from a portable subfile initially have these attributes set to zero. To modify these attribute values, use the Format tab on the Measure property sheet.
Transformer automatically interprets the following components of the portable subfile dictionary.
Integer and float data from portable subfiles are represented by their .psd datatype as follows:
Integers stored as Portable Zoned in the subfile appear as signed, zero-filled numbers.
For example, the number 16, stored in Portable Zoned Size 6 format, appears as +00016.
Float data stored as Portable Float in the subfile appears in scientific notation.
For example, the number 812,333.65, stored in Portable Float format, appears as +.8123336500000000000E+06.