How to compare two excel sheets and mark "Duplicate" in the remarks column of Sheet 2?

Help Activities
, ,
1

Hello All,

I have two excel sheets. I want to compare two columns in each sheets and remark as “DUPLICATE” if found a duplicate.

Please refer the attached excel.

New Microsoft Excel Worksheet.xlsx (9.4 KB)

2

Hi @jijorhohim98 ,

use below mentioned workflow

image
image833×670 19 KB

If(dt.Select(“[PV Number]=”+CurrentRow(“PV Number”).ToString+“”).Count>1,“DUPLICATE”,Nothing)

Thanks,
Rajkumar

3

Hi @jijorhohim98,

check attached Xaml

Sequence3.xaml (8.5 KB)

4

Hi Rajkumar,

Thanks for responding back.

Since I’m using older version of studio, I couldn’t find this activity. Is there a package which has this activity ?

5

Says the document is invalid

6

Hi @jijorhohim98,

install below mentioned package

image