Generate sequential numbers when importing with a Data reader

Kazuyuki Kawahara

I want to generate a sequential number column when importing data into Board using a data reader.

Can you do it?

Kazuyuki Kawahara

Helmut Heimann

https://community.board.com/discussion/18132/generate-sequential-numbers-when-importing-with-a-data-reader

You may find some more information in this question in our forum

https://community.board.com/discussion/18035/is-there-an-etl-function-for-counting-row

Generally, it is possible to generate such a sequence when loading SQL data, but you can't achieve that when your datasource is an ASCII file.
If you want to add a row number to your ASCII data you will have to do that prior to loading into Board by some sort of script. It's pretty easy to do that in python, for example.

Kind regards

Helmut