Hi All, I’m working on final assignment of ui path certification. Im trying to filter the rows where ‘Status’ is ‘open’, 2)‘Type’ is ‘WI4’ 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…

@Naveen_Akula Are you using Linq or Filter Datatable?

@Naveen_Akula Check below :point_down: [image] Level 3 training Exercise 2 problem with Datatable arguments filtering and assign Academy Feedback Hi Guys, I can assign the select to a datarow array right? because my workflow fails when I do. I created a variable WILis…

@supermanPunch I’m using Filter DataTable

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

@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

@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

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

Filter Not Working

Learning Hub Academy Feedback

mz3bel (Mohssine HILAL) March 16, 2020, 12:16pm 3

@Naveen_Akula

Check below

Topic		Replies	Views
Issue While Filtering DataTable Academy Feedback studio	7	1292	February 3, 2020
FILTERED TABLE Help	8	1895	November 30, 2018
Issue with filter datatable Help	15	6685	October 25, 2018
Filtering Data based on value in double format doesn't filter at all Academy Feedback datatable , activities , data_scraping	15	3209	March 11, 2020
Filter not working as expected Academy Feedback	17	2076	September 3, 2019

Filter Not Working

Related topics