Filter value and replace values?

Help Activities
, ,
1

I want filter a column Type if value type like “#N/A” then replace the cell value as “New”

But If you read excel #N/A , It show value -2146826246 as below.
image

Please guide me about it

Can any one please help on this

2

@fairymemay,

  1. Read sheet,
  2. Create int variable with value 2,
  3. Use For each row activity & put if condition inside for each row as below,
    For each row in datatavle {
    if row(“Order Type”).tostring.contains(“New Regi”){
    use write cell activity with int variable “A”+intVariable.tostring
    }
    increment int variable by 1.
    }
    PS: Variables are not created therefore workflow has errors.

image
image614×713 43.6 KB

If you follow the explanation and screenshot then you will achieve it.

Cheers,
Pankaj

3

@Pankaj.Patil if row(“Order Type”).tostring.contains(“#N/A”) , I will change to New Regi.

But I try read by row if row = #N/A ----> Message box show -2146826246 as below.
image

How to check value ?

4

@fairymemay,

dont check NA value check only new registration, if there is new registration it means that cell does not have NA value

5

Hi,

If the preserve format option is not checked while using read range/read cell …can you once try checking it and then filter it with #N/A

1 Like
6

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