How to get the filtered excel output in a datatable?

[hkjobs1988 (Hitshs Kumar)]

Thanks @aksh1yadav your solution worked out,

you keep helping people so below is one more way suggested by @ClaytonM

How to Filter Data Table

Hey, So I found the problem was with the ImportRow method. I’m not exactly sure why that wasn’t working. However, you don’t really need to do that unless you have an existing table you are adding to. So what I did was change the Assign activity to filter the rows directly to the datatable skipping over the Invoke Method. Below are screenshot and workflow. [image] 93428c340311b3e34de3f661b6498eee59e8999f.xaml (18.6 KB) You’ll need to change the Data Scrape and Excel Scope back to how you h…