topic Re: Fill Data Table Columns with Sequential Data in Discussions

Fill Data Table Columns with Sequential Data

LambdaCapybara4 — Sat, 10 Jun 2023 23:50:47 GMT

Hello,

a newbie question:

Is there an option to use the "Fill" option with the sequential character ordinal data?

Currently the sequence of Character data is only repeated, and is not continued.

For example, I write "User 1", "User 2", "User 3", and want to continue the sequence till the end of the table (100 rows)
if I highlight the data I've entered and choose the "Fill to end of table", i get the repetitions of the first three rows.

Thanks in advance

Re: Fill Data Table Columns with Sequential Data

jthi — Sun, 10 Jul 2022 08:11:53 GMT

You could create one column with the numbers from 1-100 and then other with only "User". Then use formula to combine those two, remove formula and remove the original columns.

Column with "User" values should be first in the table

Then remove unnecessary columns if needed

Select Remove Formula here

Re: Fill Data Table Columns with Sequential Data

txnelson — Sun, 10 Jul 2022 11:25:26 GMT

I find a little JSL can go a long way for simple tasks such as this.

New Table( "example",
	add rows( 100 ),
	New Column( "sequence", character, set each value( "User " || char( Row() ) ) )
);

Re: Fill Data Table Columns with Sequential Data

Georg — Sun, 10 Jul 2022 11:33:29 GMT

In addition to jthi and Jim here how the formula can be built interactively as well:

(view in My Videos)