Steps to complete Practice Exercise 2:
1) Use the UNION TOOL to unite tables Start 2.1 and Start 2.2, with Auto Config by Name Configuration
2) Use the SUMMARIZE TOOL Summarize the join result with the following configurations:
a) Grouping by the first 4 columns in the original join output order;
b) Selecting Min from the 5th column (Annual Transactions)
3) Use the TEXT TO COLUMN TOOL and configure | as separator.
4) Use the SELECT TOOL to drop the first column and Rename the other columns
5) Use the JOIN TOOL to join both outputs by specific fields. Select Customer_ID as left and right options. Remove the Right_Customer_ID column from the output.
