Adding output column based on filter criteria applied

Question

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 1Data 2Data 3Filter ReasonID1A1AID2B5BID3C3 ID4D11ID5A5AID6B2BID7F22ID8U9

Elias_Nordlinder · Accepted Answer

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