Add Row Number to Dataset Sim aids?

rfolkes · July 13, 2023, 2:23pm

Want to add the row number to a dataset.

Col
A, B, C

becomes

Col
A, B, C, D

with the value in Col D = the row number

I thought I could do something like

View("Select *, Row_Number()", Dataset) but that doesn't work.

pturmel · July 13, 2023, 2:36pm

selectStar({path.to.dataset}, idx(), '_rowIdx', 'I')

Strictly speaking, view() can do this too, just slower:

view("Select *, _r", {path.to.dataset})

rfolkes · July 13, 2023, 2:42pm

i get error Unknown function: 'idx'

pturmel · July 13, 2023, 2:44pm

That function is new in V2:

{ As is selectStar. }

rfolkes · July 13, 2023, 2:48pm

Will take a look at V2

Thanks