Collection Filter of two columns

[RajsudhapriyaCN]

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
------------------------------

[Mukeshh_k]

Hi @RajsudhapriyaCN :  Filter like this using AND operator :

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

------------------------------
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
------------------------------

[RajsudhapriyaCN]

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

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

[Mukeshh_k · Accepted solution]

@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
------------------------------