Filter activity

Help Activities
,
1

Hi All,

i am using filter activity and want to filter out few values, means if these values is available in column then it should filter out, but not allowing me to filter out, why.
img for reference

image
image1390×276 33.6 KB

And there is no option to add values one by one.
image
image728×516 9.96 KB

2

Hi

Would recommend to have a view on this doc which has segments with explanation of each filed in FILTER DATATABLE activity and also an example of how to use it

Hope this would help you

https://docs.uipath.com/activities/other/latest/user-guide/filter-data-table

Cheers @RAKESH_KUMAR_Tiwari

3

@RAKESH_KUMAR_Tiwari

Are you passing the values as a Array of String? Instead of String?

Because you need to pass the values as a String

Thanks,
Srini

4

Hi @Palaniyappan ,

can you pls let me know this error.

Filter Data Table: the value for argument ‘Column Name’ is not set or is invalid.

image

i checked properly there is no space in column name as well

5

Is the spelling correct @RAKESH_KUMAR_Tiwari

6

ok, spelling was incorrect, thanks it is working as excepted.

one issue is there, i have written below formula to calculate something and write in each cell, it was working fine, but suddenly what happened don’t know. below is the formula.
“=IF(L2<=7,”“0-7"”,IF(L2<=14,““8-14"”,IF(L2<=29,”“15-29"”,IF(L2>30,“”>30"“,”“NA”“))))”

And how it is appering in excel
image
how to fix ir, pls help, and in this step every time BOT is not able to write the formula, it throws error that excel is using and i have kill the excel before that but still it throws error sometimes.

1 Like
7

Fine

  1. Use the kill process activity before to excel activity
    If needed use a Delay activity as well before to it

  2. Formula might because of no value in referring column
    Would suggest to check once whether the referred column has some values in excel before writing the formula

@RAKESH_KUMAR_Tiwari

8

@RAKESH_KUMAR_Tiwari

Place a breakpoint after the datatable Variable

Now check in Locals how the Column you are getting

Hope this may help you

Thanks,
Srini

9

Hi @Palaniyappan ,

used kill process and delay also, and there is value on column L, img for reference
image, but still writing #REF as value in next column M.

10

Try manually once in the same sheet with the formula u have
So that we can see if there is something to be corrected in iy

@RAKESH_KUMAR_Tiwari

11

i typed and enter
image

is there is any other way of doing this? i need to calculated the Range based on L column, img ref on top Post

12

Hmm it’s something to deal with the formula and conditions involved
Would recommend to check once the condition one by one whether it matches with ur requirement

@RAKESH_KUMAR_Tiwari

13

see, what help i get from excel after clicking on help on this error.
image

14

or can you write a macro for this? so that i will just call the macro

15

@RAKESH_KUMAR_Tiwari

Try this forumla

“=IF(A2<=7,”“0-7"”,IF(A2<=14,““8-14"”,IF(A2<=29,”“15-29"”,IF(A2>30,“”>30"“,”“NA”“))))”

Also the Quotation marks make as the normal Quotations

image

Just replace A1 to L2 as you mentioned

Hope this may help you

Thanks,
Srini

16

Manually, it is working fine, but why bot is not able to calculate.

image

17

@RAKESH_KUMAR_Tiwari

Can you check the Range is iterating or not, because that is In variable
Check that

Thanks,
Srini

18

yes, it is iterating, in all cells, it has written #REF

19

@RAKESH_KUMAR_Tiwari

Can you place the cursor to on of the #REF and see in the Formula bar whether it is writing correctly or not

You can share the screenshot covering those

Thanks,
Srini

20

image
image1337×129 11.2 KB