Sources: Adding a unique numbering ID column

dszl136154 · February 24, 2012 10:30AM

Is there any way to add a column with unique numbers (eg. 1,2,3,...) ID column?

chris · February 24, 2012 10:36AM

Hi,

In DataManager connect a "Field organiser" block and add a new field "ID". Now expand the new field and select "Use formula" and enter the formula "CURRENTROW()".

dszl136154 · February 24, 2012 10:39AM

Thanks Chris.

tjbate · June 29, 2012 1:05PM

Another way to do this is to use a 'Sequence of values' source block and merge the column of sequential numbers into your data using the 'Record number' field in the source data and the 'Value' column created by the Sequence of values block.

Welcome!

Categories

Ideas Parade

Tagged