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

Hello everyone,
I have been trying to filter “#N/A” values using filter data table activity. I’ve tried “Column” = “#N/A” and “Column” Contains “#N/A” as shown below. All I can get is empty data table. Can anyone please help me?

na filter

Thanks in advance!

1 Like

@Zeki_Berk_Gokkaya
The value “#N/A” is considered as empty value while reading the datatable so try as below

image

Hey @Zeki_Berk_Gokkaya

Can you please provide a sample of DataTable?


Consider #YOK values as #N/A

There will be much more data later on

It does not work, unfortunately

@Zeki_Berk_Gokkaya
Try this
FilterDatatable.zip (8.6 KB)

This is a bit different from my excel file.
I have cells with formulas that returns #N/A values

Hey @Zeki_Berk_Gokkaya

When you’re using ‘Read Range’ activity, make sure to enable PRESERVE FORMAT checkbox in properties panel. Then you could use aforementioned snap in your question.
image

And it’ll remain the same while filtering datatable. You can use “KONTROL”=“#N/A”

2 Likes

@Zeki_Berk_Gokkaya
Could you please share your excel?

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 :point_down:

Cheers,
Mohssine

1 Like

Veri Takip 2021.xlsx (2.9 MB)

Could you please check the “Ana Tablo” worksheet?

Hi,
After reading Excel, the NA values ​​on the control column come as less than zero, so you can filter as less than zero in the filter data table.It works this way

image

1 Like

@Zeki_Berk_Gokkaya
Its working at my end. Here you go
FilterDT.zip (1.6 MB)

Run the sample program and Please check the sheet1 in Veri Takip 2021.xlsx|

1 Like

That is completely what I was looking for. The easiest way. Thanks Ceyda!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.