How to reformat a data table

ptnguyen

I have a multiple-row table of which the columns are "lot", "x", "y", "name" and "value" 

lot	x	y	name	value
1	1	1	parameter 1	200
1	5	2	parameter 1	210
1	3	8	parameter 1	198
1	1	1	parameter 2	30
1	5	2	parameter 2	31
1	3	8	parameter 2	29.5
2	1	1	parameter 1	203
2	5	2	parameter 1	197
2	3	8	parameter 1	205
2	1	1	parameter 2	33
2	5	2	parameter 2	28.7
2	3	8	parameter 2	29

How do I wirte a JMP script to reformat the table into

"lot", "x", "y", "parameter 1", "parameter 2"

lot	x	y	parameter 1	parameter 2
1	1	1	200	30
1	5	2	210	31
1	3	8	198	29.5
2	1	1	203	33
2	5	2	197	28.7
2	3	8	205	29

pmroz

You would use the split command:

dt << Split( Split By( :name ), Split( :value ) )

To get this JSL code, click on Tables > Split and enter the following:

After doing this, click on the red triangle next to Source in the resulting table and select Edit.  This will bring up the JSL.