Assign Sequence number

[PassION_es]

Hello Alteryx,

I have a workflow where I need Alteryx to automatically assign DM number to each unique reference in the output produced.  I am thinking of an Analytic App (blank field) where the user will input the last DM number used.

Example: If the user fills in DM-20053 in the Gallery/server, the output should produce output with the next assigned DMs (DM-20054, DM-20055, etc.) in a sequential order.  Thank you in advance.

[OTrieger]

@PassION_es 
Your idea should work, I guess you will need to parse the field and then concatenate it back to be a code.

What is your question?

[binuacs]

@PassION_es you can use the multi-row tool for your use-case

[PassION_es]

Hi @binuacs , I am unable to open your attached workflow because you used a newer version.  Please note that DM number should be based on the unique identifier, which in this case the "Reference Number". Thank you.

[PassION_es]

Apologies @OTrieger , my question is how to assign DM based on the Reference number.  In my sample input, I have 3 lines with the same Reference number and for that we should assign one DM number only.  Thank you.

[PassION_es]

I was able to open the workflow by dragging it to the canvas without opening.

[binuacs · Accepted solution]

@PassION_es 

[PassION_es]

Thanks @binuacs.  Great logic to use Unique and Join tool.  I was focused inside multi-row formula.