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
And there is no option to add values one by one.
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
Are you passing the values as a Array of String? Instead of String?
Because you need to pass the values as a String
can you pls let me know this error.
Filter Data Table: the value for argument ‘Column Name’ is not set or is invalid.
i checked properly there is no space in column name as well
Is the spelling correct
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.
And how it is appering in excel
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.
Place a breakpoint after the datatable Variable
Now check in Locals how the Column you are getting
Hope this may help you
used kill process and delay also, and there is value on column L, img for reference
, but still writing #REF as value in next column M.
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
i typed and enter
is there is any other way of doing this? i need to calculated the Range based on L column, img ref on top Post
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
see, what help i get from excel after clicking on help on this error.
or can you write a macro for this? so that i will just call the macro
Try this forumla
Also the Quotation marks make as the normal Quotations
Just replace A1 to L2 as you mentioned
Hope this may help you
Manually, it is working fine, but why bot is not able to calculate.
Can you check the Range is iterating or not, because that is In variable
yes, it is iterating, in all cells, it has written
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