Adding output column based on filter criteria applied

[Swati_Kejriwal]

Hi all, am trying to add an output column and populate the filter criteria reason. My filter criteria has more than 20 criteria which is spread across multiple columns. So if a row is meeting one of the filter criteria the the output column should populate the corresponding value from the source column. If more than one filter criteria is met then the output should be based on the first 

Sample:

Filter Criteria [Data 2] = "A" OR [Data 2] = "B" OR [Data 3] = "1" OR [Data 3] = "2"

Data 1	Data 2	Data 3	Filter Reason
ID1	A	1	A
ID2	B	5	B
ID3	C	3
ID4	D	1	1
ID5	A	5	A
ID6	B	2	B
ID7	F	2	2
ID8	U	9

[Elias_Nordlinder · Accepted solution]

Hello @Swati_Kejriwal ,

I have done an example workflow below, can you see if this meets your requirements?

* If you use an IF Clause, it will automatically populate with the first

criteria first, second criteria after and so on.

* First IF Clause is first criteria.

- IF [Data 2] IN ("A","B") THEN [Data 2]

* Second IF Clause is second criteria.

- ELSEIF [Data 3] IN (1,2) THEN [Data 3]

* Third IF Clause will be third criteria.

- ELSEIF blablabla = blablabla THEN blablabla

* Fourth IF Clause will be fourth criteria etc. etc.

(I use the IN clause in stead of the one you provided as it

is a short version of using OR.)

[Data2] = "A" OR [Data2] = "B" is the same as
[Data2] IN ("A","B")

Let me know if this will help you in your workflow 🙂

//Regards

Elias

[Swati_Kejriwal]

yes it worked. Thank you so much !!