Alteryx Designer Discussions

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

Check consecutive column values

tanvir_khan
8 - Asteroid

Hi all:

 

I need to pick those rows from a dataset which have 3 or more consecutive column [A - E] values more than or equal 10. Here John & Jack should be picked as 3 or more consecutive columns hold values >= 10. Can anyone suggest how to perform this search in Alteryx?

 

NameABCDE
John01020300
Paul3090280
Jack156570188

 

Thanks

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @tanvir_khan 

 

Here is how you can do it.

Workflow:

atcodedog05_1-1633080408429.png

 

 

1. Using record id tool to set row id.

2. Using transpose tool to convert columns to rows.

3. Using multi-row formula tool to check consecutive greater than 10 values.

4. Using summarize tool to get max occurrence of consecutive greater than 10 values.

5. Using filter to keep only record id with the occurrence of consecutive greater than 10 values is more than 3.

6. Using join tool to keep only those rows with the occurrence of consecutive greater than 10 values is more than 3.

 

Hope this helps : )

tanvir_khan
8 - Asteroid

Hi @atcodedog05 awesome, thanks a ton!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @tanvir_khan 

Cheers and have a nice day!

Labels