Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi-Row Formula Question

insomned
8 - Asteroid

Hello, 

 

I would need the Multi-Row formula to take EVERYTHING after a field with a certain word and before an empty field. 

 

For instance, 

 

CAPTAIN

John Jake

7 Oaks Lake

 

Hello

 

I want the formula to take 

John Jake

7 Oaks Lake (ie, everything after the word "CAPTAIN" and before an empty field).

 

Thanks!

 

1 REPLY 1
caltang
17 - Castor
17 - Castor

Again, you can try:

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors