Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Level II

## Populating the data in new table with variable defined in script

Hi all,

Actually i am trying to perform a calculation in jmp script, i have defined these calculation using a variable. ( ie- a,b etc), now i trying to populate this variable into a new table, such that each time if input changes , calculation will change and new data will be populated in new table.

let us assume a= weibull function( consider every input i have for calculating a)

``````dt = New Table( "Result",
New Column( "X",
Expression,
"Nominal",
Set Values( {a} )
)
);``````

in new table i am getting output as a, not the value of a. i want value of a to be populated.

Thanks,

Dilip

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

## Re: Populating the data in new table with variable defined in script

I think you may need to add some rows the table.

``````dt = New Table( "Result" );

// Method for inserting a function
b = Expr(
Random Uniform( 1, 10 )
);
dt << New Column( "Y", continuous, "nominal", formula( Name Expr( b ) ) );

dt << add row( 5 );
``````

In the first example, setting the values of column X automatically generated the rows.

3 REPLIES 3
Highlighted
Community Manager

## Re: Populating the data in new table with variable defined in script

Hi @dilipkumar ,

Not knowing what the variables (a, b, etc.) might contain, here are two examples if the variables contain a list or a function, that will populate the column with the values defined by the variable and not the variable itself,

``````dt = New Table( "Result" );

// Method for inserting a list or a matrix
a = [1, 2, 3, 4];
dt << New Column( "X", Continuous, "Nominal", Set Values( a ) );

// Method for inserting a function
b = Expr(
Random Uniform( 1, 10 )
);
dt << New Column( "Y", continuous, "nominal", formula( Name Expr( b ) ) );``````

Hope that helps.

Highlighted
Level II

## Re: Populating the data in new table with variable defined in script

My variable is function, it return some values,
i tried using your second example, i am getting empty data table named " Result"
Highlighted
Community Manager

## Re: Populating the data in new table with variable defined in script

I think you may need to add some rows the table.

``````dt = New Table( "Result" );

// Method for inserting a function
b = Expr(
Random Uniform( 1, 10 )
);
dt << New Column( "Y", continuous, "nominal", formula( Name Expr( b ) ) );

dt << add row( 5 );
``````

In the first example, setting the values of column X automatically generated the rows.

Article Labels

There are no labels assigned to this post.