Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Always select the "cell" 1 down and 2 across


Is it possible to always take a reference "cell" that contains a title such as HELLO and then select further cells based on this?





So in the above case, always find hello and then 2 down and 3 across?


Hope this makes sense


I think we'll need a little more information about the use case and perhaps some sample data to give a good answer.


At first glance, perhaps joining on record ids would be a first approach. I.e. record Id tool, add 2 to record Id and join to original data and then extract the appropriate column's data.

Alteryx Certified Partner
Alteryx Certified Partner

This was a nice challenge to round off my day!


I've attached an example workflow which i've documented to provide you guidance on how it works.