IDAX.SPLIT_TEST_S - Split specific returned strings into an output table

The SPLIT_TEST_S function splits the strings that are returned by the CHISQ_TEST_S_AGG, the T_TEST_S_AGG, the T_LS_TEST_S_AGG, or the T_ME_TEST_S_AGG functions and then returns a table with the extracted values.

Syntax

IDAX.SPLIT_TEST_S(testResultString VARCHAR(1024))

Parameter descriptions

testResultString
Mandatory.
The result string that is returned by the following functions:
  • CHISQ_TEST_S_AGG
  • T_TEST_S_AGG
  • T_LS_TEST_S_AGG
  • T_ME_TEST_S_AGG
Data type: VARCHAR(1024)

Returned information

Returns TABLE(STAT double, DF double, ALPHA double, BETA double, VAR double) that contains the split content of the string.

The content depends on the function for which the result string is split:

  • For the result strings of T_LS_TEST_S_AGG, all columns of the returned table are filled.
  • For the result strings of CHISQ_TEST_S_AGG, T_TEST_S_AGG, or T_ME_TEST_S_AGG, only the first two columns are filled.

Example

SELECT STAT, DF FROM (SELECT IDAX.CHISQ_TEST_S_AGG(TOTAL_BUY_FREQ, TOTAL_BUY) AS RES FROM SAMPLES.CUSTOMER_CHURN), TABLE(IDAX.SPLIT_TEST_S(RES));