This seems like it should be easy to do, but I can't figure it out. I'm trying to identify runs by looking at a field called 'STEP'.
I used a Multi-Row tool for 'STEP-1' which looks at the previous step value. When 'STEP-1' = 0 and 'STEP' > 0, it's a new run and I want a new column to start with '1' as the run. The next time the test passes (goes from 0 to a non-zero number), I want run '2' listed, which would be the current value + 1.
When I try and reference the Output Column (Step_Test) in the formula tool, it gives me an Unknown Variable error.
Solved! Go to Solution.
Many thanks, that worked!!!!
Happy to help : ) @mattcoleman
Cheers and have a nice day!
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |