Filter data table not working for two things?

[Kalle77 (D.M)]

I have data scraped a list of rankings, and I try to filter it to give me USA players with ranking less than 2700.

This above filter data works, it gives me the USA players if I try to print it out.

Then I try to filter the ranking, but then it just prints this:

This is the my table data:

If someone can help, i would really really much appreciate it!!

[pradeep931 (Pradeep Bandharam)]

Hi @Kalle77

Could you remove double quotes for “2700” value make it to 2700 and check

[Kalle77 (D.M)]

Thank you for helping me! But it didn’t fix it, still the same result in printing

[pradeep931 (Pradeep Bandharam)]

Change the “Column Name” to Column Index Value with 5

[Raj_esh (RM)]

Output your data table after extraction and see the headers, pls check if it’s coming as column 1,2etc and another row of actual header name and then the values. If this is the case you might need to remove the first row

[pravallikapaluri]

Hi @Kalle77

While Extracting the table,Try by capturing from row1 not from the headers.
And then Wile filtering Remove “” from 2700

Regards

[Krishna_Raj]

@Kalle77
Check the condition is greaterthan equal to
Then
Print values data table to string use outputdatatable activity

Activities - Output Data Table

Remove " from value

[Kalle77 (D.M)]

Thank you! But it still prints the same.

[Kalle77 (D.M)]

This is what I get if I print text from the first filter data activity only. But when I try to do both filter datas and print, it gives me the one I add in the original post.

[pradeep931 (Pradeep Bandharam)]

In the input datatable you have passed already filtered datatable value “UsPlayers” there change it to ExtractDataTable and remove the double quotes for 2700

[Varsha_PH]

Hi @Kalle77 ,

Try this Linq USPlayerRank= ExtractDataTable.AsEnumerable().Where(Function(row) row.Field(Of String)("Column-3") = "USA" AndAlso row.Field(Of Integer)("Column-4") < 2700).CopyToDataTable()

[Kalle77 (D.M)]

I dont understand. Do I put that to assign activity?

[Varsha_PH]

Hi @Kalle77,

To filter your data as needed, you’ll want to use two Assign activities:

1. Assign 1: USPlayerRank = ExtractDataTable.Clone()
2. Assign 2:

   USPlayerRank = ExtractDataTable.AsEnumerable().Where(Function(row) 
   row.Field(Of String)("Column-3") = "USA" AndAlso row.Field(Of 
   Integer)("Column-4") < 2700).CopyToDataTable()
   

Note : Provide the exact column names as your datatable

[Raj_esh (RM)]

Could you try getting the type of column 4 ?

[Kalle77 (D.M)]

Thank you so much for your effort. Anyways, I got for using that a error: “Assign: Unable to cast object of type ‘System.String’ to type ‘System.Int32’.”

[Raj_esh (RM)]

Try this where rank is a variable of data type datatable.

The issue was because the extracted table data type is string , and you were comparing a string with an integer

[Raj_esh (RM)]

This is because the column 4 is of data type string.

[Kalle77 (D.M)]

Thank you, I tried this but its still the same error. I dont understand. I used “ready” named variable instead of rank for some reason. It’s variable datatype is Datatable.

[Raj_esh (RM)]

Can you show the assign expression pls

[Kalle77 (D.M)]

You mean this?