Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Classify a customer as valid/invalid based on Status

Ravireddy
5 - Atom

My requirement is to classify customer id into valid/invalid based on the status. I have two status OPEN and CLOSE. For any customer if the two consecutive status is same then it is invalid.

For example: Open, Close-Valid

Open Close Close - Invalid

 

so in the below example only first customer id a123 is valid and remaining two are invalid. Can anyone please help with a solution to solve this requirement.

 

Customer IDStatus
a123Open
a123Close
a123Open
x345Open
x345Open
x345Close
x345Close
b112Open
b112Open
b112Close
3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

@Ravireddy there's a few ways to approach this.

 

You could use the multirow formula tool, or perform a concatenation and search of the string.

 

The workflow attached shows an example of the latter.

 

ConcatStatus.png

 

Ben

Kenda
16 - Nebula
16 - Nebula

Hey @Ravireddy

 

Here is an example using the Multi-Row Formula tool to solve your problem. If you need all 10 rows in the output, just join by Customer ID. See the attached workflow.

Ravireddy
5 - Atom

Thanks a lot @BarnesK

Labels