cancel
Showing results for 
Search instead for 
Did you mean: 

Collection Filter of two columns

RajsudhapriyaCN
Level 3

Hi All,

I have to Filter in collection two columns 

For example- in this excel in need to filter type and code of the company 
output is to get type= fruit and code of product = 1

customer Product type Code of product
1 Apple Fruit 1
2 Tomato Vegetable 6
3 Onion Vegetable 2
4 grapes Fruit 3
5 potato Vegetable 2
6 banana Fruit 4
7 mango Fruit 1


i used filter collection comment "[type] = 'Fruit'" & "[Code of product] = '1'"

can any one help .How to use condition to filter 

Regards,
Sudha



------------------------------
Rajsudhapriya CN
------------------------------
1 BEST ANSWER

Helpful Answers

@RajsudhapriyaCN - for that just add one more OR operator condition :

"[type] = 'Fruit'
AND
([Code of product]='1' OR [Code of product] ='3')"




------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------
Regards,

Mukesh Kumar

View answer in original post

3 REPLIES 3

Mukeshh_k
MVP

Hi @RajsudhapriyaCN :  Filter like this using AND operator :

"[type] = 'Fruit'
AND
[Code of product]='1'"

33688.png



------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

Regards,

Mukesh Kumar

@Mukesh Kumar What If I have to  get type= fruit and code of product = 1 and 3



------------------------------
Rajsudhapriya CN
------------------------------

@RajsudhapriyaCN - for that just add one more OR operator condition :

"[type] = 'Fruit'
AND
([Code of product]='1' OR [Code of product] ='3')"




------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------
Regards,

Mukesh Kumar