I have an excel file which contains Columns “i”,“Counter” and “Date”. I want to create a process which increments the counter to +1 and when the “Counter” of “i1” reaches to 10 it should assign the work to “i2” and so on.
Please suggest any working approach for this process.
You can achieve it with the variables. Initialize two variables as count and inspect (just assuming).
Count should be incremented as usual in the screenshot and in the if condition, if the count reaches the value 10, then again assign it to ‘0’ and increment the inspect variable to 2.
For resetting after 24 hours, you can use System.DateTime.Now().