PsiTransform(Model, Input_Data, [Header])

Transforms the Input_Data using a Transformation model stored in PMML format.  Note:  If using a version of Excel that does not support Dynamic Arrays, this function must be entered as an Excel array.  

Model:  Range containing the stored Transformation model in PMML format.   

Input_Data:  Range containing the new data for transformation. Range must contain a header with column names and at least one row of data containing the exact same features (or columns) as the data used to create the model.

Header:  If True, a heading is inserted above the returned results

Output: One or multiple columns containing a header and transformed data.

Supported Models

  • Transformation
    • Rescaling
  • Text Mining
    • TF-IDF Vectorization (input data – text variable with the corpus of documents)
    • LSA Concept Extraction (input data – term-document matrix, where columns represent terms and rows represent documents)

Previous related PSI Scoring functions: N/A

Algorithm Stored Model Sheet
Rescaling Rescaling_Stored
Text Mining