SQL Call
SELECT * FROM CFilter (
ON sports_combinations AS InputTable
OUT TABLE OutputTable (cfilter_sports_out)
USING
TargetColumns ('sport1','sport2')
JoinColumns ('player')
) AS dt;
Output
SELECT * FROM cfilter_sports_out ORDER BY 1,2,3;
col1_item1 col1_item2 col2_item1 col2_item2 cntb cnt1 cnt2 score support confidence lift z_score
---------- ---------- --------------- --------------- ---- ---- ---- ------------------ ------------------- ------------------ ------------------ -------------------
baseball baseball basketball soccer 1 4 1 0.25 0.09090909090909091 0.25 2.75 -0.4999999999999999
baseball baseball basketball lacrosse 1 4 1 0.25 0.09090909090909091 0.25 2.75 -0.4999999999999999
baseball baseball basketball golf 1 4 2 0.125 0.09090909090909091 0.25 1.375 -0.4999999999999999
baseball baseball golf tennis 1 2 1 0.5 0.09090909090909091 0.5 5.5 -0.4999999999999999
baseball baseball golf basketball 1 2 4 0.125 0.09090909090909091 0.5 1.375 -0.4999999999999999
baseball baseball lacrosse basketball 1 1 4 0.25 0.09090909090909091 1.0 2.75 -0.4999999999999999
baseball baseball soccer basketball 1 1 4 0.25 0.09090909090909091 1.0 2.75 -0.4999999999999999
baseball baseball tennis golf 1 1 2 0.5 0.09090909090909091 1.0 5.5 -0.4999999999999999
baseball basketball basketball soccer 1 4 1 0.25 0.09090909090909091 0.25 2.75 -0.4999999999999999
baseball basketball basketball golf 1 4 1 0.25 0.09090909090909091 0.25 2.75 -0.4999999999999999
baseball basketball basketball lacrosse 1 4 1 0.25 0.09090909090909091 0.25 2.75 -0.4999999999999999
baseball basketball golf golf 1 2 1 0.5 0.09090909090909091 0.5 5.5 -0.4999999999999999
baseball basketball lacrosse lacrosse 1 1 1 1.0 0.09090909090909091 1.0 11.0 -0.4999999999999999
baseball basketball soccer soccer 1 1 1 1.0 0.09090909090909091 1.0 11.0 -0.4999999999999999
baseball golf golf tennis 1 2 2 0.25 0.09090909090909091 0.5 2.75 -0.4999999999999999
baseball golf tennis tennis 1 1 2 0.5 0.09090909090909091 1.0 5.5 -0.4999999999999999
basketball baseball golf basketball 1 1 4 0.25 0.09090909090909091 1.0 2.75 -0.4999999999999999
basketball baseball golf golf 1 1 2 0.5 0.09090909090909091 1.0 5.5 -0.4999999999999999
basketball baseball lacrosse basketball 1 1 4 0.25 0.09090909090909091 1.0 2.75 -0.4999999999999999
basketball baseball lacrosse lacrosse 1 1 1 1.0 0.09090909090909091 1.0 11.0 -0.4999999999999999
basketball baseball soccer basketball 1 1 4 0.25 0.09090909090909091 1.0 2.75 -0.4999999999999999
basketball baseball soccer soccer 1 1 1 1.0 0.09090909090909091 1.0 11.0 -0.4999999999999999
golf baseball tennis tennis 1 2 1 0.5 0.09090909090909091 0.5 5.5 -0.4999999999999999
golf baseball tennis golf 1 2 2 0.25 0.09090909090909091 0.5 2.75 -0.4999999999999999
soccer soccer tennis track and field 2 2 3 0.6666666666666666 0.18181818181818182 1.0 3.6666666666666665 2.0
soccer soccer track and field tennis 2 3 2 0.6666666666666666 0.18181818181818182 0.6666666666666666 3.6666666666666665 2.0
soccer tennis tennis track and field 2 2 2 1.0 0.18181818181818182 1.0 5.5 2.0
soccer tennis track and field track and field 2 3 2 0.6666666666666666 0.18181818181818182 0.6666666666666666 3.6666666666666665 2.0
tennis soccer track and field track and field 2 2 3 0.6666666666666666 0.18181818181818182 1.0 3.6666666666666665 2.0
tennis soccer track and field tennis 2 2 2 1.0 0.18181818181818182 1.0 5.5 2.0