How to filter a column with changing value?

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.

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.

1 Like

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

Hi @rayaz

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



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