Apply Factors to Other Data

 

This tool allows the user to apply the factors that have been calculated by a MultiRate analysis to another dataset, exporting the results in SQL Table and/or CSV format. The output table will have the same layout as the Training Detail Table and the Test Detail Table. To do this, select Tools -> Apply Factors to Other Data from the menu bar.

 

The window below will appear, where the user should select the table containing the other data. The table selected must contain all of the fields (with the same names and SQL data types) that were selected from the Training Data to run the analysis. Check the boxes for the output format(s) desired and name the SQL Table if it is being created.

 

 

 

Apply to Other Data Output Table

 

Table Name: OutputPrefix_[SQL Table Name Selected]

 

Apply to Other Data Output Table Layout:

 

Field Name

Data Type

Explanation

KeyID

data type of the KeyID

The Detail Key for each record

Exposure

float

The amount of Exposure for each record

Target

float

The amount of Target  for each record

Model_Target

float

The Modeled Target for each record

Modified_Target

float

The Modified Target for each record (this includes Curve Modification)

value_characteristic1

data type of the characteristic

The value that characteristic 1 takes for each record

factor_characteristic1

float

The modeled factor for characteristic 1, as of the final iteration

value_characteristic2

data type of the characteristic

The value that characteristic 2 takes for each record

factor_characteristic2

float

The modeled factor for characteristic 2, as of the final iteration

...

 

 

...