Filter Datatable Problem

Help Robot
,
1

Excel Sheet :

image

I am tring to filter out the #N/A values of this excel sheet using the filter datatable activity but somehow the result I am getting is like this

image

The N/A Values are also showing up as Negative Numbers Which I am not Expecting

Any help is appreciated

2

Could you share how input file looks like ?

3

just show us the datatable after filtering when using the immediatepanel during a debug

4

Hi @Ishan_Shelke ,

Could you first check the Contents of the Datatable after Read Range ?

You could Debug and check the contents whether the values are actually being read as negative numbers.

Also, Give a try on Preserve Format option in Read Range and check the contents.

5

You were correct the #N/A values are being read as negative numbers is there a way to tackle this ?

6

Preserve Format Option Did the Trick Thanks :slight_smile:

1 Like
7

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