Hi Friends Need Quick help here! I have two data tables DT1 and DT2 now I need to compare row by row any one of the column from DT1 to third column of DT2 i.e “c” column (DT2 contains three columns like A,B,C) if i found match in column “C” I need to get the row value of column “A” in DT2 and …

Comparing two different columns row by row in two different datatables

Palaniyappan (Forum Leader) September 27, 2019, 12:47am 2

here you go with a xaml
hope this would help you resolve this
LOOKUP.zip (19.4 KB)

Update excel datatable

Topic		Replies	Views
How to compare row by row in excel using different sheet Academy Feedback datatable , excel , activities	22	1924	August 6, 2020
How to compare two data tables and look for not matching row columns data? Studio datatable , excel , activities , question	3	692	January 6, 2023
Compare two datatable Help activities , studio	9	2446	November 27, 2019
Comparing two data tables Help activities , question	38	40858	July 25, 2022
Compare 2 datatables, write match to next column where they match Help datatable , excel , uiautomation , activities , question	12	2501	December 7, 2020