Filter Multiple data at a time

[AsitabhaDeb]

Hi All,

I have one collection where column name is "Block reason" = Sales Block, pricing block.
I need to filter out all blocks at a time and want to keep "      " = empty cell. How would I write filter collection code. Please help me asap. Its urgent.


------------------------------
Asitabha Deb
------------------------------

[david.l.morris]

Could you show an example of what you mean? I don't understand what you're asking.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

[AsitabhaDeb]

In my collection there is a column name "Block Reason". There are block Block reason mention against each Sales Order#.

For eg = Sales Order# 6058795782-100 = Pricing Block
​                                     6245893578 - 100 = Sales Block
                                     6289745230 - 100 = 

I want to filter out all the sales orders which has under block at a time and only keep SO# 6289745230 - 100 as it has under no block.

I hope now you understand what I mean.

------------------------------
Asitabha Deb
------------------------------

[GopalBhaire]

Hi,

Is this inside one cell or in 3 seperate rows and are 3 seperate column, would be better if you can attach a screenshot.

Thanks,

Gopal

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[AsitabhaDeb]

It is two different column.

1st column                               2nd Column
Sales Order No                        Block Reason
6058795782-100                      Pricing Block
​6245893578 - 100                    Sales Block
6289745230 - 100    

I want filter only 3rd SO.             

------------------------------
Asitabha Deb
------------------------------

[MatthewBlease]

Filter Collection:

" [Block Reason] = ' ' "         ​
(Just delete the space inbetween the single quotes - I have left it in to show they are single quotes and not double quotes)

------------------------------
Matthew Blease
RPA Developer
Lloyds Banking Group
Europe/London
------------------------------

[AsitabhaDeb]

Hi,
As this is a huge excel file I am unable to apply filter. So, I want to apply filter directly in the Column.
Will it be possible. If yes, how?

BR/Deb

------------------------------
Asitabha Deb
------------------------------