Filter on the basis of two excel sheet

Help Studio
, ,
1

I have two excel sheet, let say A and B
I want to remove all those rows from sheet A in which it contains values of first column of B Excel sheet

2

we can find the matches with the help of a inner join.
Based on this we can calculate the non matchtes

find starter help here:
Find_Common_NonCommon_By1Col.xaml (12.3 KB)

3

Dear Ankita,

Out of many approaches to your query,I have attached a xaml depicting 2 of them:

Approach Sequence1:

1.Read data from both sheet
2.Filter Common data using InnerJoin
3.Remove the common records from SheetA

Approach Sequence2:

1.Read data from both sheet
2.Merge the data from both sheet
3.Extract Unique records.
4.Clear the Sheet and write the unique data in SheetA not present in SheetB

ForumDupRecords.xaml (8.7 KB)
EXCELDB.xlsx (14.6 KB)

Hope this helps.

Thanks,
Geetishree Rao