Hello,
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.
I tried modifying its value before (as I was trying to access a specific index) but failed. I haven't tried to set its value to null though (which I guess is more logical in your case since you want to totally remove the variable).
Try something like this in a SQL Select node (I haven't tested it though):
select null as AppNameIndex from dual