topic JSL - table transformation in Discussions

JSL - table transformation

Vadim — Sat, 10 Jun 2023 23:32:41 GMT

Hello,

I have a table consisting of batch number of devices, columns of Bin # and number of devices in this bin.

For example for batch #11: bin 18 has 43 devices, bin 19 has 223 devices...

Is there a way to transform that table to have columns name as bin# and cell values as number of devices in that bin.

Thanks in advance,

Vadim

Re: JSL - table transformation

txnelson — Mon, 28 Jun 2021 19:11:11 GMT

Go to the pull down menu

Tables=>Transpose

Re: JSL - table transformation

Vadim — Mon, 28 Jun 2021 21:53:46 GMT

I have tried but with no success

Trying to explain better my problem:

I created new columns with names Bin 18, Bin 19, Bin 20... I need to fill corresponding columns with values from columns "# Passed X-200".

So for batch 11 columns Bin 18, Bin 19, Bin 20, Bin 21, Bin 22 with 43, 223, 131, 29, 4 respectively.

Re: JSL - table transformation

txnelson — Mon, 28 Jun 2021 23:12:46 GMT

I think the solution is to first stack the 2 groups of columns, and then to split the columns by the stacked bin values.

My Sample data table......your data, just only 4 Chan and 4 #Passed columns

Go to

Tables=>Stack

and perform a Multiple series stack

It creates a table that looks like:

Now go to

Tables=>Split

and split the data based upon the column called Data that has the Bin values

It produces the following table which I believe is what you want, minus the exact names for the columns

Here is the steps to do the above in a script,

names default to here(1);

dt = Open("Example.jmp");

// → Data Table( "Example" )
Data Table( "Example" ) << Stack(
	columns(
		:Chan A, :Chan B, :Chan C, :Chan D, :"#Passed A-200"n, :"#Passed B-200"n,
		:"#Passed C-200"n, :"#Passed D-200"n
	),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" ),
	Number of Series( 2 ),
	Contiguous,
	Output Table("Stacked")
);

// Split data table
// → Data Table( "Untitled 17" )
Data Table( "Stacked" ) << Split(
	Split By( :Data ),
	Split( :Data 2 ),
	Group( :Batch ),
	Remaining Columns( Drop All ),
	Sort by Column Property,
	Output Table( "Final")
);

Re: JSL - table transformation

Vadim — Mon, 28 Jun 2021 23:15:22 GMT

Thanks a lot!!!