Start Free Trial

Alteryx Designer Desktop Discussions

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

Muli-Row Help

FabianAvina
7 - Meteor

Hi, 

 

I am trying to use the multi-row formula to extract the first two values in a row and then skip down and pull the next set of data points based on a condition. See the example below. For example I want to extract "1533 WXPN-FM" then skip down and have it extract "3001-WXYX-FM". Can anyone help me with the formula for this?

 
 
 

 

 

 

 

1 REPLY 1
Prometheus
12 - Quasar

If your condition is to only allow records where Document Number/Type is an actual number, you can use REGEX_Match([Document Number/Type], '^\d+') in a Filter tool.

Capturing Data.PNG

Labels
Top Solution Authors