Hey everyone, I have 2 excels (1 is main excel, second is check excel) , what I need is compare these 2 datatables’ “Material” column. On the matching rows I want to write match/no match to “State” column on the main excel. I want to do it without using loops. I know there is a way to do it but I…

@jntrk Can you check this workflow : MatchedValuesUpdated.zip (87.8 KB) I was not able to implement it completely in Linq and Update the excel, as it would lead to disrupting the formats present. But I have used the Material Code from Other Sheet to fetch the Indices of the matching Code from Raw …

Compare 2 datatables, write match to next column where they match

Help

Mulya_Habibi_Tullah November 27, 2020, 9:57am 5

Topic		Replies	Views
Compare 2 excel and write row according to it Help datatable , excel , activities , question	4	666	December 1, 2020
Compare two data tables in different excel files Help datatable , excel , activities	21	20582	January 21, 2020
Matched and Unmatched data in excel Help datatable , excel , activities , question	10	3073	March 5, 2020
Compare two datatable and update the first datatable and write to same excel Studio datatable , excel , studio	2	1130	May 23, 2022
Compare two datatables and find the match Studio datatable , excel	1	1851	May 15, 2020

Compare 2 datatables, write match to next column where they match

Related topics