Alteryx designer Discussions

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

Multi-Row Formula Tool Query

Highlighted
8 - Asteroid

Hi Team,

 

This is my input

172

172

154
265
265

 

How do I get this result - for two values if it sees it should say Yes

 

Like this -

172yes
172yes
154no
265yes
265

yes

 

 

Highlighted
13 - Pulsar

Hi @stevegeorge,

 

this should to the trick:

 

grossal_0-1590255960415.png

 

The Formula is pretty simple, if the previous or the next name is the same, I write 'Yes'.

 

grossal_1-1590256003005.png

 

 

Sample workflow attached. Let me know if this solves your problem.

 

Best

Alex

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @stevegeorge I mocked up a workflow that produces your output. Let me know what you think?

 

MulitRow_23052020.JPG

Labels