1st table: csv 2nd table: xlsx I have to compare this two files and match the reference id. Check if ABCD123 appears in both files, and check the YesOrNo, if is yes, update the xlsx attending column to yes [image]

Hey @lllqw Try this workflow This will surely help you Compare column.xaml (7.4 KB) Try to change the sheet names Regards Sreejith S S

Matching variable in 2 datatables

lllqw October 6, 2022, 8:56am 3

what about not based on current row but the value in both data table?

Topic		Replies	Views
Read 2 dataTable if id matched that enter the column from dt2 to dt1 Help datatable , activities , question	6	1192	January 20, 2020
Compare and update two data tables Help datatable , activities , question	4	909	December 22, 2019
Compare 2 excel sheets data Activities excel , activities , question	3	1013	July 18, 2022
Excel compare 2 Column Activities excel , activities , studio	9	1099	October 10, 2022
Update excel datatable Help	10	2947	October 21, 2019