Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Identifying the number sequence

shankar12
8 - 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

2 REPLIES 2
KOBoyle
11 - Bolide

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

ponraj
13 - Pulsar

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

 

WorkflowWorkflow

Labels