cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
JoshC
Level I

Selecting Column By Modeling Type in JSL

Hello,

 

I am trying to perform the following actions on a data table:

 

Add a row >> Select all Columns Based with Numeric Data Type >> Add a "0" to the New Row in all of these columns >> Add Equal Number of New Columns at End of the Data table as those selected >> Insert Formula into the New Columns Created >> Rename New Columns Based of Formula Reference Column.

 

The biggest issue I am having at this point in selecting the columns based on Modeling Type or Data Type. 

 

The purpose of this is to remove duplicate values in columns base on value in the previous row. The parameters being analyzed in project maintain the same value until a new analysis is called for. This creates scatter plots with "plateaus" due to the repeating values. I am trying to eliminate the plateauing to better overlay trends from multiple parameter measurements. Any help would be greatly appreciated. Thanks.  

 

2 REPLIES 2

Re: Selecting Column By Modeling Type in JSL

Give this a shot:

 

Names Default to Here( 1 );

dt = Current Data Table();
dt << Add Rows( 1, At Start );
For( i = 1, i <= N Cols( dt ) , i++, If( Column( i ) << Get Data Type() == "Numeric", Column( i )[ 1 ] = 0 ) )

Does this handle the part you're struggling with?

Ross Metusalem
JMP Academic Ambassador
Georg
Level VII

Re: Selecting Column By Modeling Type in JSL

This snippet selects the numeric columns:

 

names default to here(1);

dt= open("$SAMPLE_DATA\Big Class.jmp");
dt << select columns(dt << get column names("Numeric"));
Georg