community
cancel
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

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