Filter Not Working

[Naveen_Akula]

Hi All,

I’m working on final assignment of ui path certification. Im trying to filter the rows where

1. ‘Status’ is ‘open’,
   2)‘Type’ is ‘WI4’
2. WIID is greater than 300000.

Im able to get data for first two scenarios, when i add scenario 3, i dont see any data in my excel. I tried putting the value 300000 with quotes and without quotes. No luck!!.

[supermanPunch (Arpan)]

@Naveen_Akula Are you using Linq or Filter Datatable?

[mz3bel (Mohssine HILAL)]

@Naveen_Akula

Check below

Level 3 training Exercise 2 problem with Datatable arguments filtering and assign

Hi Guys, I can assign the select to a datarow array right? because my workflow fails when I do. I created a variable WIList an array of DataRows [image] When I try to assign [image] [image] It faults (I was debugging and in the output pane) [image] This is within the init block of the main workflow Main.xaml (57.4 KB) The reason that this wasn’t working was because my datatable varriable dtworkitems was null as my Extract Structured Data activity wasn’t working because the default v…

[Naveen_Akula]

@supermanPunch I’m using Filter DataTable

[Naveen_Akula]

@mz3bel Thankyou for your reply. But this doesn’t help since i’m using filter DataTable. Pls check below SS

[Doanh]

@Naveen_Akula
Filter Datatable activity work well with STRING data, but it’s problem with INT value even through you put 300000 inside " "
You should use other method to filter data in this case

[supermanPunch (Arpan)]

@Naveen_Akula Can you try this Expression in an Assign Activity :
ExtractDatatable = ExtractDatatable.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals(“Open”) and row(“Type”).ToString.Equals(“W14”) and Convert.ToDouble(row(“WIID”).ToString)>300000).CopyToDataTable

[Akshay07 (Akshay Suryawanshi)]

Hi @Naveen As its a string use Equals or contains method for first two and for last one remove the double quotes (" ") in value.