Creating an ID for the rows

#1

Hi!

I am trying to generate IDs for my data, say AFK00001, AFK00002 … and so on which will be assigned to each row in the dataset.

Is there a way to generate such a column?

Regards,
AK

#2

Yes, you can use either the Enumerate Rows action and then use an expression to modify it as necessary. The expression can be something like

'AFK' & padstart([RowNo], '0', 5)

Alternatively, use the Generate UIDs action.

#3

Thanks for a quick reply. Appreciate that.

Cheers,
AK

#4

You’re welcome! :slight_smile: