community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Select Tool - with a formula, possible? Or a better solution possible?

Highlighted

Hello, new and posting again. Thank you for your help and patience. 

I am trying to take financial statements that run vertically and have company name in row 1 and all information below. I only need 10 companies so I was using the "Select tool" to manually select each company I need. Given that requests change over time and there are hundreds to scroll through - is there any more efficient way to do a "select"? I was thinking a formula similar to how filter works.

If i am not clear I could post more information. Thank you again

Alteryx Partner

You should take a look at the Dynamic Select tool, configured to use a formula. If you can provide a sample dataset I could try and put something together to make it more clear.

 

Let me know if this helps,

 

Cheers!

Magnetar
Magnetar

Another option might be to use a Transpose tool, depending on how big your data is.


That way you could transpose by company name, and use a filter to select everything else

Labels