hello. i’m having problem with my project. when i run my project it skip some value. [1] [2] [3]

Hello @ldiaz , An alternative would be to use VLookup activity link: https://docs.uipath.com/activities/docs/v-lookup-x It seems that there is a mess with all those 3 datatables dt1, dt_update and dt_output, that if condition and the nested for each row. Hope it helps! Best regards, Marius

Automation in excel

Help Something Else

ldiaz (Leonardo Diaz) September 29, 2022, 11:02am 7

something like this
if the trimPNNUMBER is detected in the 2nd excel(LOOPUP PN NO.) it will write something in the MSME and MSME (term) column

Topic		Replies	Views
Compare two excel documents and show differences - Please help Help datatable , excel , activities	13	2776	September 2, 2019
Read 2 dataTable if id matched that enter the column from dt2 to dt1 Help datatable , activities , question	6	1192	January 20, 2020
Compare 2 datatables problem Studio studio , question , activities_panel	9	655	January 6, 2023
Comapring multiple coulmns in Excel Files Help datatable , excel	6	1539	September 17, 2019
To Compare two excel & get unique rows based on column Activities excel , activities , question	10	808	March 10, 2023

Automation in excel

Related topics