cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Fill Data Table Columns with Sequential Data

LambdaCapybara4
LambdaCapybara4
Level II
Created: Jul 10, 2022 03:34 AM  |  Last Modified: Jun 10, 2023 4:50 PM 1479 views

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

0 Kudos
3 REPLIES 3
jthi
Super User jthi
Super User


Re: Fill Data Table Columns with Sequential Data

Jul 10, 2022 04:11 AM (1473 views)  |  Posted in reply to message from LambdaCapybara4 07-10-2022

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.

jthi_0-1657440553704.png

jthi_1-1657440592828.png

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

jthi_2-1657440641026.png

Then remove unnecessary columns if needed

jthi_3-1657440672559.png

Select Remove Formula here

jthi_4-1657440692576.png

 

 

 

-Jarmo
txnelson
Super User txnelson
Super User


Re: Fill Data Table Columns with Sequential Data

Jul 10, 2022 07:25 AM (1464 views)  |  Posted in reply to message from jthi 07-10-2022

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() ) ) )
);
Jim
Georg
Georg
Level VII


Re: Fill Data Table Columns with Sequential Data

Jul 10, 2022 07:33 AM (1459 views)  |  Posted in reply to message from LambdaCapybara4 07-10-2022

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

JMP User 123.mp4
Current Time 0:00
Duration 1:13
Loaded: 0%
Stream Type LIVE
Remaining Time 1:13
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
    • en (Main), selected
    (view in My Videos)

     

    Georg

    Recommended Articles