Hi!!!, Today, i have 2 Excel files and i want to compare the col 1 of the Dt1 and the col 2 in the Dt2, search de duplicate columns and delete it from Dt1, how can i do that?

In output column tab, you need to mention the columns which are needed as output.

Compare Excel file with another

nadim.warsi (Nadim Warsi) October 29, 2018, 7:26pm 2

See this thread:

1 Like

Topic		Replies	Views
Filter excel data where duplicate data in each column to remain the same Help datatable , excel , studio , question	5	1101	November 8, 2020
Compare 2 excel files with the same columns and remove all duplicats Help datatable , excel	5	1844	March 23, 2020
Compare two different excel columns and matched remove data in second excel sheet Studio studio , question , project_panel	19	876	July 7, 2023
Comparing two excel file Help excel	3	3058	March 22, 2018
Remove duplicate rows from two datatables based on a specific columns Activities excel , linq	8	1497	August 31, 2022