$1.$ Create a workflow named Northwind. Import the customers.csv and orders.csv file into Alteryx. How many columns and rows does each table have?

$2.$ Use a join tool to join the two files on customerID. Connect customer data to the L input port and order data to the R input port of the Join tool. Uncheck the right customer key when you join. How many columns and rows does the joined file have?

$3.$ The Join tool has three output ports. L means the data only in the left table, in this case, data in the customer table but not in order table. Those are the customers who did not place any orders. The J port holds data that are in both tables, which are the customers who placed orders. R port holds data that are only in the right table $$ the order data. Those are the orders that without a customer associated with them. How many customers never placed orders?

$4.$ Use the auto field tool to change the data types. Connect the tool to the J output port of the join tool.

$5.$ Convert the three date columns to the correct data type using three Date$/$Time tools. Currently they are recognized as string data type. You can use MM$-$dd$-$yyyy$.$ The names for the new date columns are Order$\_$Date, Required$\_$Date and Shipped$\_$Date.

$6.$ Use a text to column to split the contactName into two columns using the delimiter $\backslash$s $($There are some names with middle names. It is not a perfect solution but we will not deal with these names here$).$

$7.$ Use a Select tool to unselect contactName, orderDate, requiredDate and shippedDate. And rename the two name columns for the contact name $$First$\_$Name$$ and $$Last$\_$Name$$

$8.$ Use a formula tool to get the number of days that it takes to ship an order. Create a column $$days to ship$.$ See the screenshot for the formula and make sure you change the data type to int$16.$ How many days does it take for an order to ship?

$9.$ Use a summarize tool to get the number of orders for each CustomerID. You need to group by CustomerID and count OrderID.

$10.$ Sort the number of orders descendingly, and then use a sample tool to choose the top $5$ customers with the highest orders. Take a screenshot.

$11.$ Annotate the tools in the workflow Take a screenshot of the entire workflow.

$12.$ Export it as a packaged file.