@KimBragg
To achieve your goal in Alteryx, you can indeed use a combination of tools to filter, summarize, and update your data with the most recent information based on a specific category. Here is a step-by-step approach:
Input Data Tool: This will be your starting point to import the data file into Alteryx.
Filter Tool: Use this tool to filter the data based on the specific category you are interested in.
Sort Tool: Sort the data by the category and date, ensuring that you have the most recent dates at the top for each category.
Unique Tool: This tool will help you to keep only the first occurrence of each category, which should be the most recent one due to the previous sorting step.
Join Tool: To update the data with the more recent information, you will use this tool to combine the original data with the filtered, most recent data. You can set up the join to replace the old data with the new data based on the category.
