Filtering the Data Table with the Values "#N/A"

Hi Everyone,

Can somebody please help me to get the result to filter the data table with Value “# N/A”

I have used the Filter data table activity on the Column and the Operation used as IsEmpty.
But still not getting the row items with “# N/A”

Any advice please.

Thank you very much


Use String.equals("#N/A"), should work!

1 Like

You can use, select method of the datatable and filter the column based on your condition

ExtractDataTable.Select(“[Column Name]=’# N/A’”).copytoDatatable

1 Like

Hi Vishnu,

Refer this post. It would help

1 Like

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