Checking the sequence of invoice number

[NehaNevrekar]

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

[Raj_Singh1]

Hi @NehaNevrekar ,

is it possible to have more information like sample input column and then desired column, with some 10-20 values populated. 

[NehaNevrekar]

Hey Hi Raj,

I have attached the sample invoice number. I want to check whether they are in sequence or not. I would want a separate column saying whether it is in sequence or not.

For instance: Last invoice number was 1233. If suppose the last invoice number is not provided then the first number from the below series should be in sequence always.

Invoice Number	Whether in sequence
1234	In sequence
1235	In sequence
1237	Not in sequence
1239	Not in sequence
TIN1234	In sequence
TIN1235	In sequence
TCN1267	In sequence
TCN1270	Not in sequence
ABC-7654	In sequence
ABC-7655	In sequence
ABC-7666	Not in sequence
XYZ / 257	In sequence
XYZ / 259	Not in sequence
ABC-2011/2020	In sequence
ABC-2111/2020	Not in sequence

[Raj_Singh1]

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

[messi007]

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

[AM]

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.