Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

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

Grouping Lines on a Sheet

briankuhlmann
7 - Meteor

I have a sheet full of orders. A blank line separates each customer order. Is there a way to identify all lines before a blank as a group? This way when I add a record ID it would label all lines within a group with the same number?

3 REPLIES 3
JosephSerpis
16 - Nebula
16 - Nebula

Hi @briankuhlmann I mocked up a workflow that I think answers your question. Let me know what you think?

briankuhlmann
7 - Meteor

looks good, thanks!

trorvig
5 - Atom

I believe this task could be done using a multi-row formula. I created some dummy data in a simple fashion you described.

 

MRF.JPG

 

For this example I selected only the field 'Order #' but if the entire row is blank I believe any field could be chosen.

Labels