Hello Everyone
I am new to Alteryx development. Kindly help.
This is the requirement.
a. Create a new column called Priority.
b. Sort the due date in ascending order.
c. If the Due Date <= Current Date Then that row alongwith all the previous rows, plus, the rows that falls on the next working day, must be marked as "P1" in the column Priority.
d. The above must be only for those rows where the invoice amount >= 500.
I have given the data below
Please help.
Thanks
Bobji
Duplicate Group | Due Date | Invoice Amount | Priority |
191989 | 13-01-2021 | 4,556.00 | |
192012 | 17-03-2021 | 500.00 | |
192103 | 26-05-2021 | 342.00 | |
192044 | 11-09-2022 | 456.00 | |
192010 | 27-09-2022 | 5,670.00 | |
192019 | 02-11-2022 | 2,939.00 | |
191968 | 10-12-2022 | 3,949.00 | |
192005 | 30-12-2022 | 12.00 | |
192021 | 12-01-2023 | 444.00 | |
192024 | 20-01-2023 | 333.00 | |
191996 | 04-02-2023 | 5,959.00 | |
191971 | 04-05-2023 | 29,293.00 | |
191990 | 28-05-2023 | 3,98,484.00 | |
192019 | 17-06-2023 | 3,434.00 | |
191984 | 20-06-2023 | 7,878.00 | |
191991 | 27-06-2023 | 3,434.00 | |
191920 | 05-07-2023 | 67,776.00 | |
191913 | 17-07-2023 | 4,556.00 | |
191927 | 21-07-2023 | 500.00 | |
191927 | 26-07-2023 | 342.00 | |
191934 | 22-08-2023 | 456.00 | |
191980 | 25-08-2023 | 5,670.00 | |
192007 | 25-08-2023 | 2,939.00 | |
191987 | 29-08-2023 | 3,949.00 | |
191979 | 09-09-2023 | 12.00 | |
191983 | 16-09-2023 | 444.00 | |
192016 | 05-10-2023 | 333.00 | |
192026 | 09-10-2023 | 5,959.00 | |
192022 | 12-10-2023 | 29,293.00 | |
191942 | 14-10-2023 | 3,98,484.00 | |
191942 | 14-10-2023 | 3,434.00 | |
191937 | 14-10-2023 | 7,878.00 | |
191925 | 16-10-2023 | 3,434.00 | |
191939 | 16-10-2023 | 67,776.00 | |
191903 | 17-10-2023 | 4,556.00 | |
191902 | 17-10-2023 | 500.00 | |
191924 | 18-10-2023 | 342.00 | |
192046 | 21-10-2023 | 456.00 | |
191972 | 23-10-2023 | 5,670.00 | |
192006 | 24-10-2023 | 2,939.00 | |
191906 | 25-10-2023 | 3,949.00 | |
191868 | 28-10-2023 | 12.00 | |
191945 | 30-10-2023 | 444.00 | |
191945 | 30-10-2023 | 333.00 | |
191936 | 31-10-2023 | 5,959.00 | |
191974 | 31-10-2023 | 29,293.00 | |
191996 | 02-11-2023 | 3,98,484.00 | |
192043 | 03-11-2023 | 3,434.00 | |
191992 | 04-11-2023 | 7,878.00 |
Solved! Go to Solution.