I am learning UiPath and want create a robot for below case study and need your expert assistance to it please:
Explanation: I have 2 excel files A & B. need to pick a column cell value from A, find it in another excel B; if found, place its respective row to a new sheet C (Need to perform this to a sheet of more than 1000 records)
Case A: Create New Excel C.1. for all searched A cell value found in B
Case B: Create New Excel C.2. for all searched B cell value found in A
Case C: Create New Excel C.3. that are not found in A and B
the code has a part of if → Then, that creates the common values,
if i need the Uncommon value, what code/logic shall i include in the Else that creates another sheet with only missing row amongst the 2 sheets?
Hi,
Create new data table using build datatable activity as similar to one in the workflow that is uploaded, add a add data row activity in else block and store to the newly built datatable and write to excel sheet using write range activty,
This will help you add unmatched vales to other sheet,
Hope this helps you jn solving the issue, please let us know if this is your solution
Hi Instead of using 2 for loops use one for loop and use select query inside for loop in if condition and then use add data row activity to write to datatable,
Please refer the below xaml file for your reference and sorry for late response, thank you for your patience.