Filter column name and copy in new Excel sheet

Hi Team,

I’m facing an issue while filtering the column of one excel sheet with other.


Consider: BlueWater- I’m expecting the result in another data table as below.

and similarly for other customer.
and if there is no matching customer name from sheet1 then just display the data availabel in sheet1

Compare Excel sheets with column.xlsx (83.1 KB) FilterTableE1 (1).xaml (32.7 KB)

Pelase advice me on how to achieve this.

HI @Vishwanth_Raya

I couldn’t go through the workflow you attached… But I can suggest some approach…

First, read the full excel to a datatable using Read Range…
Using the datatable, you can do the filtering using filter datatable activity
Now, you can write back the data in to the excel in same format…

Have you tried this approach?