Trying to complete Practice Exercise 3 from the learning path

Hello,

I used the Join tool to join the initial state and the order details. I noticed that there is an order ID associated with each customer ID. So I joined them. The results came out to 15 customer IDS. The answer is 10 order IDS with each customer. I am NOT sure what to do from there. Also, I am getting a parse error when I try to find the # of shipping date = order date - Shipping date. Also i do know that the discount is the Total saved which I do not know how to add the column. This is my work which needs some corrections.

If I cannot get the proper order #s. I cannot do the rest. The data sets are attached.

Final State - Exercise 3.yxdb

Order Details.yxdb

Practice Exercise 3.yxmd

Start 3.1.yxdb

Practice Exercise 3 my work.yxmd

Workflow

Best Practices

Accepted answers

All comments

DavidP

You only need 1 join tool to combine the 2 data sets. When joining, you have to find the common element between the 2 data sets and tell the join tool to use this field or fields to join the 2 data sets. You do this by picking the field from the left and right data sets underneath the "Join by specific fields" option.

When you look at Ship date after the 1st Select Tool, you can see that the values are all null, so changing the data type to Date did not work. This is because Ship date is not in the correct format of yyyy-mm-dd. Use a DateTime parse tool instead to convert Ship date to the right format. It will create a field with a new name, so you can then use your Select tool to uncheck the original ship date field and rename then new field to Ship date.

To get the difference in days between Order date and Ship Date, try using the DateTimeDiff() function

For Total Cost you have to multiply unit cost by quantity, add shipping cost and subtract discount. I wouldn't branch off to do this, just do it straight after your days to ship calculation.

mxledesma

David, Thanks for your reply. Let me upload what i have so far. I did what you told me but i am getting a parse error. On the datetime diff(), i am not sure what I use for "u". Once when i have the # of shipping days i can calculate the rest. Also, the other thing that concerns me is in the Join Function, i think the only element to join is the Customer ID correct?

Thanks,

Michael ledesma

grazitti_sapna

Hi @mxledesma , solution to practice exercise 3.You can refer this if you get stuck.

Practice Exercise 3 Solution.yxzp

DavidP

@grazitti_sapna, this is a little bit frustrating...

I'm struggling to understand the purpose of posting the solution to someone who's trying to learn.

Amyah

Hi, I did all the calculation but why my Days to payment result didn't come out like the final answer after using summarize tool. can you please take a look at my workflow to see where I did wrong? Thanks.