Hi,
I need to add Column 'Tracker' which will have 3 different statuses based on the 3 conditions:
Sample below:
I will be grateful for help 🙂
Solved! Go to Solution.
@Neffri
Appreciate if you would provide with Data format next time.
Hi Qiu,
Thank you for your solution.
Yes, I'm checking your workflow and the first row (RecordID=1) should have Tracer value =1. First time the value 'B' for this Record appeared in September and for the latest month it's still 'B'.
Hi @Neffri
Here is my take. Matches the expected output
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @Neffri
You can accomplish this with a simple multi-row formula
All the logic is coded in the formula
If Trim([Value]) in ("A","") and [Row-1:Tracker] = 0 then
0
ElseIf Trim([Value]) in ("A","") and [Row-1:Tracker] = 1 then
2
Elseif [Value]= "B" and [Row-1:Tracker] in (0,1) then
1
else
2
Endif
Dan
@atcodedog05 I have only one question regarding your solution. Will this REGEX_Match work if statuses A and B will be replaced with words, for example A would be replaced with "Exception" and B with "Scope" (for example). I've changed these values and it doesn't work now for some reason.
@danilang unfortunately I can't open your file because I have older version of Alteryx .