Combine two different workbooks that have one column in common which are ID’s number
Once the bot matches the ID I want it to create a new sheet show all the ID’s that match and the ones that don’t match HOWEVER combine the two ID columns into one single column of ID’s that have all the ones that were a match and not matched
The new sheet should have all columns that were in the two workbook and their information should match the rows to their respected ID’s
I already used Join Data Tables to create the new excel sheet. I’m just stuck in only having one column of all ID’s matched and not matched. Can anyone please help me?
I can do this with in this issue? But if the excel dynamically change we need to come up with another strategies.
Scenario
1.Use Excel application scope activities.
2.Use Read Range Activites and set the value to the Datatable variable(Create Variabl with datatable type).
3.Get the last row of Column(“ID nVision”).Tostring.
4.Use assgn activities and set the value of ID nVision
5.Then Delete the column of ID nVision.
6.Get the row count of id and set it to integer datatype variable.
7.Then use write cell activities to write the value of ID nVision.
unfortunately the excel will change on a monthly basis. Sometimes there are more or less IDs rows in the workbook. This was a demo excel because the original one has over 30,000 rows.
Hi @Sugaray
Good morning were still working on it! But if you want to address your issue you can use the scenario that i gave to you.And i will update you once done in figuring how to do it dynamically. My apologies @Sugaray
That’s amazing! how were you able to do it? Did you do the Modifications by some activities on UiPath? Could you please show me? was the column width also auto fixed too?
