Find string in column, rename the column and add new column in JSL

achid03 — Fri, 09 Jun 2023 19:51:46 GMT

Hi All,

I have a table like below and want to find the String "Z", "A" and "B" in the columns and rename it to "Z_A" and "Z_B".

After that, I want to add a column after X_loc and Y_loc which converts them to mm. The formula that I want to use is (X_Loc / 1000).

Can anyone guide me on how to do the scripting for this?

Thanks

Re: Find string in column, rename the column and add new column in JSL

txnelson — Wed, 07 Jul 2021 12:10:24 GMT

You need to read the Discovering JMP document, and the Scripting Guide!
You need to attempt to solve the problem first. One learns by making mistakes and figuring out what the problem is
When you fail at solving the problem, the Discussion Community is there to help.

Below is a script that if you have setup your data table correctly, should show you one way to solve the problem

Names Default To Here( 1 );

// Create a sample table
dt = New Table( "Example",
	Add Rows( 3 ),
	New Column( "ID", Character, "Nominal", Set Values( {"#1", "#2", "#3"} ) ),
	New Column( "X_loc", Set Values( [2, 3, 4] ) ),
	New Column( "Y_loc", Set Values( [2, 2, 4] ) ),
	New Column( "Z_Surce_Column_A", Set Values( [4, 5, -4] ), Set Display Width( 118 ) ),
	New Column( "Z_Source_Column_B", Set Values( [-4, -10, 1] ), Set Display Width( 133 ) )
);

// Wait 5 seconds so you can see the beginning table
wait(5);

// Loop across the columns to find the ones to change
For( i = 1, i <= N Cols( dt ), i++,
	If(
		Contains( Column( dt, i ) << get name, "Z" ) & Contains( Column( dt, i ) << get name, "A" ),
			Column( dt, i ) << set name( "Z_A" ),
		Contains( Column( dt, i ) << get name, "Z" ) & Contains( Column( dt, i ) << get name, "B" ),
			Column( dt, i ) << set name( "Z_B" )
	)
);

// Create the new column and move it to where it is to be located
dt << New Column("The New Column", formula(:X_loc/1000));
dt << go to(:The New Column );
dt << Move Selected Columns(After(:Y_loc));

You need to study the script and learn how it works.

topic Find string in column, rename the column and add new column in JSL in Discussions

Find string in column, rename the column and add new column in JSL

Re: Find string in column, rename the column and add new column in JSL