I am tasked with grouping some customers based on criteria related to certain fields that are spread across 3 of my dimension tables.
The letters below are an example of the fields in each dimension table that I need to look at to determine the group.
Partner (Dimension) = A, B,
Customer (Dimension) = C, D
Team (Dimension)= E, F
What is the best way for me to accomplish this type of grouping?
Should I create a new table by merging queries using only fields A, B, C, D, E, F? Then in the new table create a calculated column with a SWITCH statement or a conditional column?
Any input is greatly appreciated.