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

mz3bel (Mohssine HILAL) March 11, 2020, 10:50am 8

@zbigniew.lukowski

Check below

Topic		Replies	Views
Filter Data Table Activity Help	15	13584	November 16, 2018
How to filter a scraped table (from website) with integer values Help datatable , activities , data_scraping , question	2	1566	November 8, 2019
Issue with filter datatable Help	15	6695	October 25, 2018
Filtering Data Table Activity Help	28	2968	June 12, 2019
Filter data table columns but value stored as string Studio datatable , uiautomation , studio , question	5	2663	March 19, 2020

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

Related topics