To update the data to accommodate the new scenario, you need to modify the Excel file that contains the test data and then refresh the test case to reflect the changes. The steps are as follows:
Open the Excel file that has the test data for the workflow. It should have four columns: Number1, Number2, Sum, and Result.
Add a new column after Number2 and name it Number3. This column will store the third number for the sum operation.
Update the existing rows in the Excel file to include a value for Number3 and adjust the value of Sum accordingly. For example, if Number1 is 1, Number2 is 2, and Number3 is 3, then Sum should be 6.
Save and close the Excel file.
In UiPath Studio, right click on the test case that uses the Excel file as the test data source and select Update Test Data. This will open a window where you can edit the test data settings.
In the Update Test Data window, make sure that the Excel file path is correct and that the sheet name is selected. You can also change the name and description of the test data if you want.
Click OK to save the changes and close the window.
Right click on the test case again and select Refresh Test Data. This will reload the test data from the Excel file and update the test case accordingly.
You have successfully updated the test data to compute the sum of three numbers instead of two. You can now run or debug your test case with data variations1.