519401_en-US

liliconcom

Fill Data Table Columns with Sequential Data

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

Advanced Statistical ModelingMass CustomizationQuality and Process EngineeringRe: Fill Data Table Columns with Sequential Data

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

 

Re: Fill Data Table Columns with Sequential Data

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

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