Filter column name and copy in new Excel sheet

Help Studio
, , ,
1

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.

2

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?

3

Yes @Lahiru.Fernando, I have tried the same approach.
But while writing the data back to excel, it is not writing in the required format.

4

Hi @Vishwanth_Raya

If it is not writing data, that could be because you filter is not working properly… You could test this using debugging… Can you try adding a breakpoint and running in debug mode. In the locale panel, you can see the values that are available in the variables…