Search through multiple columns using IF statements

[Til4006]

Hi all,

The attached formulas work fine, but I have a large sheet of values with percentiles from 10%-90% and it would be super tedious to create all the formulas to get the results.

Any better way to approach this in alteryx?

Thanks!

[Luke_C · Accepted solution]

Hi @Til4006 

In this situation I would try transposing your columns so your TCC amount is repeated down next to each percentage. Then you could build one formula to check, filter on the positive hits, and append those back to your dataset as needed.

[Til4006]

Hi Luke,

That worked! Thanks!