Filter column name and copy in new Excel sheet

Question

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

Comments

So basically, you are facing trouble with displaying the filtered data from the two sheets? Is that your query?

---

Are you using Filter dataTable Activity or Select query to filter dataTable?

---

Yes.I'm facing the issue with displaying the filtered data. I'm using Filter Data tabe.

---

You could configure the output data table in the filter wizard I guess.

---

I have tried filter wizard, but to achieve it dynamically. As it has to compare the name from one sheet with other and it it finds then paste in th new sheet

---

In that case, may be you should use select query for filtering out the data and use assign activity along with it.