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

Invoice number sequence validation

Mahadevaswamyb
7 - 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

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

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

 Invoice_Numbers.PNG

RolandSchubert
16 - Nebula
16 - Nebula

Hi Mahadev,

 

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

 

Best regards

 

Roland

Mahadevaswamyb
7 - Meteor

Thank you, this works perfectly..!!

Srini_Advik
7 - Meteor

Capture.JPG

 

This should give the final result.

mahadevaswab
8 - Asteroid

Dear all,

 

Need one more hep.

 

Co code Invoice #

2810   2810001

2810   2810002

2810   2810003

2500   2500001

2500   2500002

 

From the above we wanted to validate the Sequence number based on the co code and then followed by Invoice number sequence.

 

Rgards

Mahadev

Labels