Dear All,
I am new to Alteryx macro development. Were I have to loop through records and provide them the end result as ok or not ok. Below is the case can some one guide me how can I achieve it.
Case: I have a set of records grouped at Area level (A & B) and assigned a sequence no (Seq)
For Each ID's in a area i need to check if my sequence is always in ascending order (Comparing with row -n) then i have to mark it as OK
in below example for ID 952 sequence is 4 but for previous id sequence is 6 which is not in order then i need to mark it as not ok. similarly for ID 3564 sequence is 9 again this is not in sequence because when i compare data with Row - 2 (i.e., 11 which is grater than 9) hence it is not in sequence and marked as not ok
Sequence.
In this case sequence is dynamic and sequence can be assigned and jumbled at any level. so, I cannot use multirow formula as row -n is not defined. for example for A we have (3 sequence assigned) and for b we have (12 sequence assigned) it can be assigned at 100's as well.
can some one help on this to achieve?
ID's | Area | Seq | Result |
101 | A | 1 | ok |
201 | A | 2 | ok |
301 | A | 3 | ok |
401 | B | -1 | ok |
501 | B | 2 | ok |
666 | B | 3 | ok |
657 | B | 5 | ok |
689 | B | 6 | ok |
952 | B | 4 | Not-ok |
11 | B | 7 | ok |
12 | B | 10 | ok |
1214 | B | 11 | ok |
2569 | B | 8 | Not-ok |
3654 | B | 9 | Not-ok |
2568 | B | 12 | ok |
Solved! Go to Solution.
Hi @Shank
Happy to help : )
This is an amazing and quite a complex problem statement this would be a great Weekly Challenge. Can I get your permission to submit this as a weekly challenge?
Cheers and have a nice day!
Thank you @Shank 🙂
I am assuming your like is a yes to submit it as a weekly challenge.
Cheers and have a nice day!