Shapley Value Functions Example 1 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 1 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