topic RE: Collection Filter of two columns in University Forum

Collection Filter of two columns

RajsudhapriyaCN — Thu, 11 May 2023 08:10:00 GMT

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

RE: Collection Filter of two columns

Mukeshh_k — Thu, 11 May 2023 08:24:00 GMT

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

RE: Collection Filter of two columns

RajsudhapriyaCN — Thu, 11 May 2023 08:35:00 GMT

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

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

RE: Collection Filter of two columns

Mukeshh_k — Thu, 11 May 2023 08:43:00 GMT

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

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