Hello, I am dealing with the below scenario.
Data:
Table1:
Brand Region Subcategory Product Code Unit Price
A USA Furniture 1001 10
1002 20
1003 30
B USA Electronics 1001 50
1002 40
1003 30
Table2:
Brand Region Subcategory Discount %
A USA Furniture 10
B USA Electronics 50
Desired Output:
Brand Region Subcategory Product Code Unit Price Discount % Amount After Discount
A USA Furniture 1001 10
1002 20
1003 30
B USA Electronics 1001 50
1002 40
1003 30
Can you guys please share your thoughts on my above scenario?
Solved! Go to Solution.
Step 1: Join Dataset 1 and Dataset 2 on "Brand", "Region" & "Subcategory"
Step 2: Use the discount % after join to calculate net amount
Thanks @ropra and @deviseetharaman for sharing your thoughts. Combining both the logic worked better for me. Thanks, both!