How to filter a column with changing value?

[rayaz]

I’m doing a project. I need help.
I want to filter a specific column and I want to create new sheet for every filtered value. When I use filter datatable activity, i have to give a column name and value. Column name won’t change but values can change. It may contain different values with new excel. What can I do?

Thank you.

[vickydas (vicky)]

Hello @rayaz
Are you saying your value is dynamic If yes than you can assign that data in a variable and use it in Filter Datatable Activity.

[rayaz]

Hello @vickydas yes dynamic value but I couldn’t do

[AshwinS2 (Ashwin S)]

Hi @rayaz

Use assign activity as new Dt=Dt.Select(“[column name]”) like’%value%'"). copytodatatable ()

Thanks
Ashwin.S

[vickydas (vicky)]

hello @rayaz
check the workflow below
FilterDT.xaml (23.8 KB)