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

Invoice number sequence validation

Meteor

Dear Team,

 

Could some one help me with the below scenario.

 

As per the below table Data is the invoice numbers and Result is what I want a workflow to drive. in each case we wanted to validate Invoice numbers are generated in the continuous sequence.

 

Data                   Result
2000000344
2000000345      Yes
2000000346      Yes
2600000271      No
2810017325      No
2810017326      Yes
2810017327       Yes

 

Regards

Mahadev

Alteryx Certified Partner
Alteryx Certified Partner

Hi @maha7060 you can do this with a Multi-Row Formula.

 Invoice_Numbers.PNG

Alteryx Certified Partner
Alteryx Certified Partner

Hi Mahadev,

 

MultiRowFormula Tool  is a practical solution for that. Find a sample workflow attached.

 

Best regards

 

Roland

Highlighted
Meteor

Thank you, this works perfectly..!!

Meteor

Capture.JPG

 

This should give the final result.

Labels