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: IdCondition 1Condition 2Condition3Condition 4Condition 5ARequiredNot RequiredRequiredNot RequiredRequiredBNot RequiredNot RequiredNot RequiredRequiredNot RequiredCRequiredNot RequiredNot RequiredNot RequiredNot RequiredDNot RequiredRequiredNot RequiredRequiredNot RequiredENot RequiredRequiredRequiredRequiredNot Required And output should look like this.. IdCondition 1Condition 2Condition3Condition 4Condition 5Condition applicableARequiredNot RequiredRequiredNot RequiredRequired1,3,5BNot RequiredNot RequiredNot RequiredRequiredNot RequiredNoneCRequiredNot RequiredNot RequiredNot RequiredNot Required1,3,5DNot RequiredRequiredNot RequiredRequiredNot Required2,4ENot RequiredRequiredRequiredRequiredNot Required2,3,4

New column populated as per multiple column values

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

Datasets

Designer Cloud

Common Use Cases

Data Investigation

Accepted answers

Felipe_Ribeir0

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.

New column populated as per multiple column values.yxmd

All comments

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

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.