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

Always select the "cell" 1 down and 2 across

Meteor

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

 

 

hello  
   
  1234

 

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

 

Hope this makes sense

Quasar

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.

 

Ben

Labels