-
Parameterize an Export Matrix analysis as follows:
-
Selected Matrix — Customer_Analysis_Matrix_Short
-
CSSCP — Enabled
-
Create Table — Enabled
-
Table Name — Twm_CSSCP_Matrix
-
- Run the analysis.
-
View the results with a Free Form SQL analysis by executing the following queries.
SHOW TABLE <result_db>.Twm_CSSCP_Matrix; SELECT * from <result_db>.Twm_CSSCP_Matrix order by 1;
Note the following results:
CREATE SET TABLE <result_db>.Twm_CSSCP_Matrix ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL ( XIDX INTEGER, XCOL VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, income FLOAT, age FLOAT, years_with_bank FLOAT, nbr_children FLOAT, marital_status FLOAT, female FLOAT) UNIQUE PRIMARY INDEX ( XIDX );
Export Matrix - Example #2 Results (Pt. 1) XIDX XCOL income age years_with_bank 0 income 367897869180.964 77558080.3574296 1799836.3975904 1 age 77558080.3574296 272572.4283802 6924.0682731 2 years_wi 1799836.3975904 6924.0682731 5340.626506 3 nbr_chil 5179600.8795181 -899.9196787 -76.6746988 4 marital_ 3656455.7389558 4332.1740295 -19.1285141 5 female -1209868.5100402 -60.3266399 -4.3895582 ...
Export Matrix - Example #2 Results (Pt. 2) XIDX XCOL nbr_children marital_status female 9600.8795181 3656455.7389558 -1209868.5100402 1 age -899.9196787 4332.1740295 -60.3266399 2 years_wi -76.6746988 -19.1285141 -4.3895582 3 nbr_chil 908.2650602 349.9076305 -3.811245 4 marital_ 349.9076305 593.6331995 .2423025 5 female -3.811245 .2423025 184.0990629