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.

image

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

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

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?