This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
First time playing about with spatial tools for this challenge. So to start off I joined the two data sets concerned with each individual store. I then used the Create Points tool to mark the points of each store coming out of the join and then another CreatePoints tool to mark each warehouse coming out of that input. Then the FindNearest tool was implemented with the store points going into the target input and the warehouse points going into the universe input with the maximum distance set at 100,000 miles. A simple formula to find the total miles was just the Distance in miles each item has to travel to get to the nearest store multiplied by the number of assigned items for that store. Summarize tool to group by the Item and sum the total miles to calculate the total distance for each item. Select tool was then used to rename a column to match that of the given output.
I enjoyed practicing with the find nearest tool, but I am not sure I understand the question being solved here. The distance item 1 will need to travel could be expressed as the total distance of item 1 from each warehouse to each store, but it seems like the solution is actually tracking the total distance traveled for the full inventory of each item being shipped to each store - the number of "assigned" is the total inventory of an item to be shipped and we have to multiply assigned*distance to get the correct answer. This seems like it is answering a question pertaining to shipping data (maybe to figure out total trucking or flight miles required for an inventory order to complete a cost calculation?) but its not entirely clear if that is the logic or not.