This keeps popping and idk why

[Law (Kim Law)]

"Source: Filter Data Table

Message: Data Table

Exception Type: System.ArgumentException"

Declared the variable correctly and the rows that needs to be filtered

[lakshman (Ganta lakshman)]

@Law

Welcome to our uipath community.

Could you please show me screenshot of your Filter DataTable activity and so that we can check and help you.

[Law (Kim Law)]

here it is

[Law (Kim Law)]

The #n/a should be unselect

[supermanPunch (Arpan)]

@Law Is the error only occurring when you give the value #N/A or even for other values, also Can you give the Full Error Description

[Law (Kim Law)]

Same thing even i have changed the values

[supermanPunch (Arpan)]

@Law Instead of Filter Datatable, Can you try this Linq:
Assign FilterTable = FilterTable.AsEnumerable().Where(Function(row)Not (row(“MATCH”).ToString.Trim.Tolower.Contains(“#n/a”))).CopyToDataTable

Tell me whether you get the Output or not.
In this way I can I figure if it’s a bug of UiPath Studio or a problem in Excel File

[Law (Kim Law)]

Can u tell me what package is needed for me to get the (AsEnumerable function) thank you

[supermanPunch (Arpan)]

@Law Normally you don’t need any Package

[Law (Kim Law)]

nothing appears

[Law (Kim Law)]

*enumerable

[supermanPunch (Arpan)]

@Law What is the Error? Can you tell me what error it shows?

[Law (Kim Law)]

after declaring the variable no items comes next so i’m back at figuring how filter wizard work

[supermanPunch (Arpan)]

@Law What is the type of FilterTable?

[Law (Kim Law)]

already changed it to string back to DataTable still error

[Lahiru.Fernando]

Hi @Law

What is the data type of the FilterTable variable? Is it DataTable type?

[Law (Kim Law)]

Yes changed it back in forth still the same error

[chenderson (Cary Henderson)]

Good evening @Law,

Does the solution in this post resolve your issue?

URGENT: Filter datatable

Hello Abdel, I hope you found the solution if not then, try replacing the #Na with Na. if you are reading data from an Excel then the #Na value get’s replaced by a numeric string when read into a data table, and because of that the filter data table doesn’t work. To overcome this you can use IFERROR function in excel along with the required function that is populating the result in the desired column. From there on, you can create a new table which should be a clone of the previous table (this…

[CBlanchard (Cammaron)]

in your filter datatable, instead of = have you tried contains?

[supermanPunch (Arpan)]

@Law Keep the Datatype of FilterTable as Datatable , Do not Change it, If you Still haven’t Found the Solution, I will tell an Alternate Method.

Open Your xaml File with Notepad or Notepad++ and Check if the Highlighted part is present or not

If Not present Add it to that section in your xaml File, but be careful while editing in xaml