I’ve generated table using “Data scraping” tool, Im trying now to filter the data table using value of WIID column < 500000, I’ve couldn’t get this code to work, I’ve tried: A) [image] kept 0 rows B) [image] kept 0 rows C) [image] Exception I also want to mention that this is data table g…

@zbigniew.lukowski Is the column “WIID” is a String or an Integer ? If it’s a String use :point_down: varWIID = Integer.Parse(“WIID”)

@zbigniew.lukowski Can you out put the data table which you are scraping and see what values you are getting. :slight_smile:

@zbigniew.lukowski Check below link :point_down: Convert Strings to Integer from DataTable

@zbigniew.lukowski use an assign statement and pass the below value to get the filtered output in a datatable.Here it is specified for WIID>500000. Datatablevariable=ExtractDataTable.AsEnumerable.Where(function(x) Cint(x(“WIID”).ToString)>500000).Select(function(x) x).CopyToDataTable

Thank you for replying , unfortunately solution produce Compiler error: [image]

@zbigniew.lukowski Check below :point_down: [image] AsEnumerable is not a member of 'System.Data.Datatable' Help Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [i…

The only solution working was looping through each row and removing them if “IF” condition was met: [image] but it’s really not efficent.

@zbigniew.lukowski Use this instead :point_down: ExtractDataTable = ExtractDataTable.select(“Convert([WIID],System.String) < 500000”).CopyToDatatable Below xaml file :point_down: StringToIntergerDT.zip (18.8 KB) Let me know if it worked for you ? :slight_smile:

[image] mz3bel: xtractDataTable.select(“Convert([WIID],System.String) < 500000”).CopyToDatatable Unfortunately not: [image]

Filtering Data based on value in double format doesn't filter at all

Learning Hub Academy Feedback

zbigniew.lukowski (Zbigniew Lukowski) March 11, 2020, 11:55am 13

I was surprised by this fact as well but checked in scope and its table:

Topic		Replies	Views
Filter Data Table Activity Help	16	13442	November 19, 2018
How to filter a scraped table (from website) with integer values Help datatable , activities , data_scraping , question	3	1545	November 11, 2019
Issue with filter datatable Help	16	6633	October 29, 2018
Filtering Data Table Activity Help	29	2885	June 15, 2019
Filter data table columns but value stored as string Studio datatable , uiautomation , studio , question	5	2631	March 19, 2020

Filtering Data based on value in double format doesn't filter at all

Related topics