Shapley Value Functions Example: ShapleyGenerateCombination, ShapleyAddOnePlayer; Step 1 - Teradata Vantage

Step 1 creates payoff tables for each combination.

Different combinations of projects are created using the ShapleyGenerateCombination function on Shapley Value Functions Example: ShapleyGenerateCombination, ShapleyAddOnePlayer; Input. The value column indicates the total cost (sum of capital cost and operating_cost) as specified in the SQL call.

SQL Call

CREATE MULTISET TABLE project_comb_cost AS (
  SELECT * FROM ShapleyGenerateCombination (
    ON (SELECT project_index, total_cost AS value_sh FROM project_cost)
  )AS dt 
) WITH DATA;

Output

SELECT * FROM project_comb_cost;

 comb  size value   
 ----- ---- ------- 
 1 2      2 14000.0
 2 3      2 19000.0
 2        1 13000.0
 3        1 10000.0
 1        1  3000.0
 1 2 3    3 20000.0
 1 3      2 13000.0