How can i compare 2 excel file and if there is a difference write it on an other excel file

Help Activities
,
41

Hi @Soudios

On which column basis you want to check the dt give that column in the if condition

42

hi @Soudios

use this condition in if activity

if = not DT2.AsEnumerable.Any(Function(r)r(“Title1”).ToString=CurrentRow(“Title1”).ToString) AndAlso not DT2.AsEnumerable.Any(Function(r)r(“Title2”).ToString=CurrentRow(“Title2”).ToString) AndAlso not DT2.AsEnumerable.Any(Function(r)r(“title3”).ToString=CurrentRow(“Title3”).ToString)

It helps!

43

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.