Hello Team,
I am new to Alteryx and need help on following.
I have first 2 existing coloumns samid and status. Now based on status value (only if forecast) i want to assign priority 1 to first 5 records, 2 to next 5 records.
Then assign Friday week ending date to priority 1 and next Friday to priority 2.
Thanks in advance
Solved! Go to Solution.
Hi Sandy,
Fun challenge - thanks! While it seems really simple it does involve a bunch of tools. The key is the Multi-Row Formula tool - you want to get familiar with that one, very helpful!
The workflow first uses a filter to separate the Forecast records.
It uses a Multirow formula to create a RowCount column - If the previous row's RowCount is 5 then start at 1 again else add 1 to the previous row (notice the option to set values for rows that don't exist to 0)
it uses another Multirow formula tool to calc the Priority - again if the previous row's RowCount = 5 then add one to the previous row's Priority else keep it the same.
Then append Friday's date to each record (this is in a Text Input tool for now)
Add of seven days times the Priority code -1 to change the week end date
Union the records together and then drop the RowCount column
Cheers,
Bob
Thanks Bob
Thanks for the reply Alex. Unfortunately i am using version 10.6 so couldn't open your workflow.