Populate a column with a serial follow the format "YYMA999999"

[JacEvaluator]

Hi, I am very new to Alteryx.

There is a requirement to populate a column with a serial follow the format "YYMA999999".

YYMA999999 where:

YY is the year

M is the month (A to L for Jan to Dec)

A is either E for export or I for import

999999 is a sequence 1 to 999999

I am trying out formula. I was successful with YY and stuck with the rest. How should I go about this?

[KGT · Accepted solution]

I assume you have  a date field called [Date]. I just used today's date for it. Without knowing what you're assigning to, some things change for different use cases, mainly the assignment of the sequence, but in this example, it's calculated by the RecordID, you can calculate it from a list or something instead if you like...

I've laid the components out in individual formulas, but of course, you can combine if needed.

[JacEvaluator · Accepted solution]

Thank you very much! It works!