Checking the sequence of invoice number

Question

Hi,

I want to check the sequence of Invoice number. The invoice number can be numeric, alphanumeric or can also contain special characters. The data may also include more than one series.

I am attaching the proforma for your reference.

Would appreciate if you can send the solution in a workflow. Let me know in case if you need additional information.

Thank you!!

Regards,

Neha

Invoice No. Sequence.xlsx

AM · Answer

Want to implement this in R. Don't have Alteryx on my machine anymore but is anyone able to explain the logical steps behind the CheckSequence.yxmd workflow. It will be super helpful to other readers in the community.

messi007 · Answer

Dear @NehaNevrekar,

Please see the attached workflow

I'll let you do the check when the invoice number is 2011/2020 as it's not clear how you calculate the sequence in this case.

However it works for the others 🙂

If this post helps, then please consider Accept it as the solution 🙂

Regards

CheckSequence.yxmd

Raj_Singh1 · Answer

this one seems bit tricky as its combination of various characters and not a consistent format.