Check consecutive column values

[tanvir_khan]

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?

Name	A	B	C	D	E
John	0	10	20	30	0
Paul	3	0	90	2	80
Jack	15	65	70	18	8

Thanks

[atcodedog05 · Accepted solution]

Hi @tanvir_khan 

Here is how you can do it.

Workflow:

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]

Hi @atcodedog05 awesome, thanks a ton!

[atcodedog05]

Happy to help : ) @tanvir_khan 

Cheers and have a nice day!