Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Would anybody know how to build this results table below using the product discount, customer and sales tables? How do you relate these 3 tables and what formula/statement to use? Thanks.
RESULTS TABLE
Customer# | Discount Level | Product # | Special Price |
Cust 1 | Bronze | B1 | $30 |
Cust 1 | Bronze | B3 | $5 |
Cust 2 | Gold | B2 | $100 |
Cust 2 | Gold | B1 | $10 |
Cust 3 | Silver | B3 | $3 |
PRODUCT DISCOUNT TABLE
Product # | Discount Level | Special Price |
B1 | Bronze | $30 |
B1 | Silver | $20 |
B1 | Gold | $10 |
B2 | Bronze | $150 |
B2 | Silver | $125 |
B2 | Gold | $100 |
B3 | Bronze | $5 |
B3 | Silver | $3 |
B3 | Gold | $1 |
CUSTOMER TABLE
Customer | Discount Type |
Cust 1 | Bronze |
Cust 2 | Gold |
Cust 3 | Silver |
SALES TABLE
Customer | Product # |
Cust 1 | B1 |
Cust 1 | B3 |
Cust 2 | B1 |
Cust 2 | B2 |
Cust 3 | B3 |
Solved! Go to Solution.
Hi,
Merge Table 2 into Table 3 based on the Customer column to bring over the Discount type column into Table 3. Merge Table 3 into Table 1 based on the Product # and Discount type column to bring over the Customer in Table 1. Now build all your visuals from Table 1.
Hope this helps.
Hi @Ashish_Mathur ,
Thank you for your quick reply. In merging table 3 into table 1, what do you mean by based on Product # AND Discount Type column? How do you achieve this merging using in a query, based on 2 columns? Thanks again.
Hi,
In the Query Editor, select Merge queries and then select the common columns of both tables.
You are welcome.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |