Best way of automatically adding row ID

[Nikita Belooussov]

Hi

I was wondering what is the best way for new rows to automatically obtain a row id column when they are refreshed,added, or loaded.

Thank you

[Colin Gray 3]

Hi there,

Spotfire has an in-built RowId() function I would use for this. So create a calculated column in the data table of interest (File->Data->Add Calculated Column, or File->Data->Column Properties then Insert->Calculated Column from drop down on top right, or if you are using Spotfire 7 - the Insert menu then insert calculated column), and type in the command:

RowId()

This creates a unique ID for every row, and each time new data is read it automatically generates new ids for the new rows.

Hope this helps.

 

Thanks

Colin

[Nikita Belooussov]

Thanks, I already know about this function. I was wondering if there was a way to have a way that anytime you import a table it will be added automatically without having me to add it. Sorry if it was unclear.

[Colin Gray 3]

Ah ok, sorry I misunderstood :)

I don't think it is possible to automatically add this column on every table insert but its an interesting and potentially useful idea. You could submit it to the ideas portal:

https://ideas.tibco.com/