nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Only manipulating column data once

tylerram93

Hello!

I have a problem where I am multiplying a column of data (a bunch of Max Currents) by 100 to get Max Current Densities, and so when I run the script it does it fine:

column(13) << set values( (Column(13) << get as matrix) *100);

column(13) << set name("Max Jc (mA/um^2)");

But if I run the script multiple times it keeps multiplying the data by a hundred and I have to close the datatable and reopen it.

Is there a way to get it to only update once?

Thanks,

Tyler

Accepted answers

uday_guntupalli

Hello @tylerram93 :

Simple way to fix this is - you make sure that the table is closed at the end of the script . As long as your raw data is consistent , irrespective of how many times you run the script and save and close it at the end as shown below - the multiplication should only happen once .

By not closing the table , you are modifying the table repeatedly I would think.

In case - I have misunderstood your question - please paste a test data set and test script .

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
column(4) << set values( (Column(4) << get as matrix) *100);
column(4) << set name("Max Jc (mA/um^2)");
Close(dt,Save(FilePath));

Best
uday

All comments

uday_guntupalli

Hello @tylerram93 :

By not closing the table , you are modifying the table repeatedly I would think.

In case - I have misunderstood your question - please paste a test data set and test script .

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
column(4) << set values( (Column(4) << get as matrix) *100);
column(4) << set name("Max Jc (mA/um^2)");
Close(dt,Save(FilePath));

Best
uday

tylerram93

That worked perfectly! Thanks!

Follow-up question:

Is there a way to select columns based off of their name? So instead of using Column(13) it can search for the column with "Max Ic (mA)"

Thanks,

Tyler

uday_guntupalli

@tylerram93 ,

This should do it .

// Open Sample Data Table 
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

// Define Column To Search For 
ColToSearch = "age"; 

// Get Column Names 
ColNames = dt << Get Column Names("String"); 

// Search if the desired column names exists 
ColNum = Contains(ColNames,ColToSearch);

// Get Reference to desired Column 
Col = Column(dt,ColNum);

// Alternatively 
Col(ColNum)  // Also refers to your desired column

tylerram93

So I have to read in two columns that I eventually go on to use for a
simple bivariate analysis: Right now it doesn't work! Thanks again for all
the help and guidance!

//define columns to search for

colSearch1 = "Corrected Area";

colSearch2 = "Max Ic";

//get columns of interest

Col1 = dt << *Get Column Names(*"Corrected Area"*)*;

Col2 = dt << *Get Column Names(*"Max Ic"*)*;

//search for desired columns

colNum1 = Contains*(*Col1,colSearch1*)*;

colNum2 = Contains*(*Col2,colSearch2*)*;

//column(13) << set values( (Column( 13 ) << get as matrix) *100);

//column(13) << set name("Max Jc (mA/um^2)");

Column1 = Column*(*dt,colNum1*)* << *set values(* *(* Column1 << *get as
matrix)* **100)*;

Column1 << *set name(*"Max Jc (mA/um^2)"*)*;

Column2 = Column*(*dt,colNum2*)*;

Close*(*dt,Save*(filepath));*

//Call CreateBivariate to do a bivariate (two variable) analysis\

status = List*(0*,*0)*;

New Window*(*"Custom Analysis",

H List Box*(*

V List Box*(*

Panel Box*(*"Controls",

Text Box*(*"Choose Analysis"*)*,

choice = Check Box*({*"Distribution","Fit Line"*}*,

current = choice << *Get(1)*;

//xParam = Column(9);

//yParam = Column(13);

xParam = Column1;

yParam = Column2;

If*(* And*(* current, Not*(*status*[**1]* *)* *)*,

dt << *Append(*

dt = V List Box*(*

bivDistribution = Distribution*(*

Y*(* Eval*(*yParam*)* *)*,

X*(* Eval*(*xParam*)* *)*,

*)*;

*)*