topic Selecting Column By Modeling Type in JSL in Discussions

Selecting Column By Modeling Type in JSL

JoshC — Fri, 09 Jun 2023 21:59:45 GMT

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.

Re: Selecting Column By Modeling Type in JSL

Ross_Metusalem — Fri, 04 Dec 2020 21:25:19 GMT

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?

Re: Selecting Column By Modeling Type in JSL

Georg — Fri, 04 Dec 2020 22:50:42 GMT

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"));