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 |
Solved! Go to Solution.
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
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.
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.
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
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
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