Alteryx designer Discussions

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

Search for Cell and Copy row below

Highlighted
5 - Atom

Hi everyone and thank you right away for your help. 

Currently I am facing the following problem: 

I want to find a specific cell (here B-Area in Column 3) and cut the entire column 5 (starting in the row where i found the String "B-Area") and paste it in Column 7. 

It is pretty difficult to explain therefore attached two screenshots: 
Thats how it looks rn: 
 

Thats how it currently looks: 

altery_Pic1.PNG

 

And that is the format I need to move on: 

altery_Pic2.PNG

 

I would really appreciate your help. 

Best regards

manfredkarl

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi!

 

If you could attach the sample data that would be great!

 

Ben

Highlighted
5 - Atom

Hi Ben, 

 

of course. I'm sorry. 

Thanks for your help. 

 

 

Highlighted
13 - Pulsar

I'd use something along these lines:

image.png

The Multi-Row Formula tool checks to see which row 'B-Area' starts on, then flags that row and all rows below it.  The Formula tool then copies the contents for every row that is flagged and empties out the cells where the data was prior.  The Select tool at the end is just to drop the flag column I created with the Multi-Row.

 

Good luck, hope it helps!

Highlighted
5 - Atom

Thank you very much. Worked perfectly this way. 


Labels