I wonder if anyone can help with this - I'm very new to Alteryx Designer...
I'm designing a workflow to parse FlexLM log files, what I'd like to do is create a running could of how many of x licences are checked out at any one time.
I have prepped the data and now have a timestamp column and a checkout column.
The checkout column contains either "OUT" or "IN" and describes whether a particular license feature (of say an arbitrary pool or 10) was checked out or checked back in.
So using this information id like to generate a *new* column ("new_column_count") of data containing a running count of licenses checked "OUT" - i.e starting with 1 have a column with a value for each row that was incremented by +1 each time "OUT" or -1 each time "IN" occurred, eg:
"checkout" "new_column_count"
OUT 1
OUT 2
OUT 3
OUT 4
IN 3
IN 2
OUT 3
IN 2
IN 1
IN 0
OUT 1
Any ideas would be much appreciated!
