How to filter excel data table which contains #N/A values

[mz3bel (Mohssine HILAL)]

Hi @Zeki_Berk_Gokkaya

Welcome to the UiPath community.

So, apparently 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.

Follow below link, it should help you fix 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…

Cheers,
Mohssine