Assign Sequence number

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.

dummy_sequence.xlsx

Tips and Tricks

Custom Tools

Common Use Cases

Accepted answers

binu_acs

@PassION_es

DM_Number_04022025.yxwz

All comments

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?

binu_acs

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

DM_Number_04022025.yxwz

PassION_es

Hi @binu_acs , 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.

binu_acs

@PassION_es

DM_Number_04022025.yxwz

PassION_es

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167