community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Identifying the number sequence

Asteroid

 

Hi,

 

From the below table data i was checking for smaller Service ID appears after higher Service ID numbers, it  should display as NO  in Sevice ID Seq. column and also without Service ID numbers also should be seen as 'No' in the Sevice ID Seq. column.

 

 

UUIDService IDEnd  DateSevice ID Seq.
118109187264 06/03/2017Yes
218109187264 06/03/2017Yes
318109187232 06/05/2017NO
418109187312 06/05/2017Yes
518109187314 06/05/2017Yes
618109187315 06/05/2017Yes
718109187313 06/05/2017NO
818109187316 06/05/2017Yes
918109187317 06/05/2017Yes
10  06/05/2017NO
11  06/05/2017NO
1218109187320 06/05/2017Yes
1318109187321 06/05/2017Yes
1418109187265 06/05/2017NO
1518109187267 06/05/2017NO
1618109187324 06/05/2017Yes

 

Thanks

Highlighted
Alteryx Certified Partner

I believe the Multi-Row Formula tool will accomplish what you need. Here is an example. I'm not sure why row 15 in your example is NO, but otherwise this workflow matches.

 

Identifying the number sequence 2018-10-03.png

Quasar

Here is the sample workflow for your case. Hope this is helpful. 

 

workflow.PNGWorkflow

Labels