I am working on a custom task which will loop over a result set, returned by a SQL SELECT statement, and do some work. To do work in a loop, I am using the next value node in my workflow. After the WF runs and next value node evaluates to False, I see in runtime data, a new variable created called AppNameIndex = # of total rows in the dataset.
I am just wondering how can I clear the value of this AppNameIndex variable once Next Value node evaluates to false? I tried setting it to 0 and to an empty string '' using set value and SELECT node but either approach didn't work.
We're on RSA Via 6.9.1 P10.