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.
I'm trying to figure out a way to have desired output below (with the same column name), but I'm not sure exactly about what kind of Alteryx tool(s) I should use. On input data, I have quantities summarized by week for some columns and also quantities summarized by more than 1 week at the same column (it's not standard, not always the same summary, quantity of weeks on the same column may vary depending on the date I run the input). Is anyone able to help me with that, please?
Thanks a lot for sharing a workflow as a solution! Nevertheless, unfortunately it was not possible to open it, showing the message that it was created by a more recent version of Alteryx, when I tried to import it.
Thanks a lot for sharing your workflow as a solution! The desired output is almost done, it's missing only divide the quantities by the quantity of weeks, when two or more weeks are splitted on two or more columns. For example, on the RecordID "1" when column "QTY Weeks 3-5" is splitted into 3, each column should appear 5,600 (16,800 / 3).
You can try opening the workflow again now, and let me know if it works. I have changed it to a yxmd file with a text input just like @jsuptic did, as opposed to using an input tool connecting to an excel file, which is why I sent it as a packaged workflow prior. Hopefully, you can take a look at it as a yxmd file now. My solution accounted for dividing by the number of weeks as well, so that should be taken care of. Let me know your thoughts!
I have another doubt, please. How about split columns into weeks when not always column name match exactly the quantity of weeks grouped at the same column? To complement the analysis, I also have start dates to each column available. I need to split by correlating with start dates instead of column names to ensure always the right quantity per week. For better understanding the issue, please, see below different input when I run the workflow on different day, now showing that column name with week period not match exactly the dates.