In my scenario say I have the variables called Employee 1, Employee 1 Stat 1, Employee 1 Stat 2, that multiple actions are occurring for such as Write Cell (Sheet X, A1, Employee 1 Stat 1) and (Sheet X, A2, Employee 1 Stat 2). Is there a way to mass update the Employee Stat 1 variable to Employee 2 Stat 1 for another set of actions? Or must each variable be updated manually from Employee 1 Stat 1 to Employee Stat 2 Stat 1?
Hi,
Can you elaborate?
In general, we can extract the above process into another workflow file, then pass these data as argument, I think.
Regards,
To elaborate further, as seen in the screenshot the bot is checking the value of CPA Employee 23 to see if it is equal to Employee 17, if it is, then it will execute the steps, if it isn’t then it will move on to check if CPA Employee 23 is equal to Employee 17. The bot will do this for CPA Employee 1 through CPA Employee 25, then it would do the same actions for Employee 18, so on and so forth.
I am hoping there is a way to group these actions, duplicate them, then mass update the Employee 17 variable to the Employee 18 variable. Else I would have to make the edit for each new group of actions.
Hi,
Can you share how you got CPA Employee 23, CPA Employee 24 etc or Employee 17, Employee 18?
Are these from Excel sheet?
If so, we can use DataTable and iterate it using ForEachRow.
Regards,
The CPA Employee # variables are coming from a report ran at the time of the bot’s running. The Employee # variables are coming from a master spreadsheet that has an employee’s stats on it. (This is done by having the bot identify the sheet index number, then referencing the cell that houses the employee’s name on their sheet.)
Both can be dynamic so the bot needs to take the value of the cell from the report, which will be the employee’s name, and find that in the master document which will give the bot the correct index number to work with.
HI,
In this case, it might be better to use Dictionary<string,string> instead of each variable.
We can get or set it dynamically as the following.
Regards,
I appreciate the alternative solution, however, I don’t believe I have access to that with StudioX.
HI,
Which version of StudioX do you use? In recent version, we can use any type variable.
The following is a simple sample regarding the above.
Sample20220330-1.zip (53.8 KB)
Hope this helps you.
Regards,