New column populated as per multiple column values

[Sakshi_M]

Hi all, 

I have a case where for every record some conditions are met while other are not.

using Alteryx, i want to create a new column that combines this information in one field.

Input data looks like this:

Id	Condition 1	Condition 2	Condition3	Condition 4	Condition 5
A	Required	Not Required	Required	Not Required	Required
B	Not Required	Not Required	Not Required	Required	Not Required
C	Required	Not Required	Not Required	Not Required	Not Required
D	Not Required	Required	Not Required	Required	Not Required
E	Not Required	Required	Required	Required	Not Required

And output should look like this.. 

Id	Condition 1	Condition 2	Condition3	Condition 4	Condition 5	Condition applicable
A	Required	Not Required	Required	Not Required	Required	1,3,5
B	Not Required	Not Required	Not Required	Required	Not Required	None
C	Required	Not Required	Not Required	Not Required	Not Required	1,3,5
D	Not Required	Required	Not Required	Required	Not Required	2,4
E	Not Required	Required	Required	Required	Not Required	2,3,4

[ShankerV]

Hi @Sakshi_M 

Can you please explain your condition applicable column.

As I see B has Condition 4 required, but not used in the output column as 4.

Many thanks

Shanker V

[Felipe_Ribeir0 · Accepted solution]

Hi @Sakshi_M 

One way of doing this. Btw, for B 4 is applicable right? And for C, only 1 is applicable. I understood applicable = Required, if it is not please tell what you understand as applicable.

[Sakshi_M]

As mentioned by Felipe, Required = applicable. 

The output was manually populated.. so it must be an error from my end to have missed some conditions.

[Sakshi_M]

Yes.. your assumption is right, Thanks for a quick turnaround.. I am trying to implement this now.. 
Hope there can be a more concise solution

[ShankerV]

Hi @Sakshi_M 

Tried to make it concise, but tried to eliminate only one or 2 steps.

But with a total different approach.

Check if it helps!!!

Many thanks

Shanker V

[ShankerV]

Hi @Sakshi_M 

Could you please check and confirm whether it worked.

If yes, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V