topic Re: How to interchange columns using JSL? in Discussions

How to interchange columns using JSL?

UserID16644 — Mon, 11 Nov 2024 08:26:44 GMT

Hi all,

I have a CSV file that is being used in JMP. However, I need to interchange columns 1 & 2 with Columns 7 & 8. How to do it using JSL. It looks something like this:

Original File

Interchanged columns

Re: How to interchange columns using JSL?

jthi — Mon, 11 Nov 2024 08:46:56 GMT

Do you wish to reorder your columns or just move the data around inside the columns? This should help you with re-ordering of the columns BUT it won't work the same with all JMP versions due to how <<move selected columns did work in some version(s)

Names Default To Here(1);

dt = New Table("Untitled 2",
	Add Rows(0),
	Compress File When Saved(1),
	New Column("1", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("2", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("3", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("4", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("5", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("6", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("7", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("8", Numeric, "Continuous", Format("Best", 12), Set Values([])),
	New Column("9", Numeric, "Continuous", Format("Best", 12), Set Values([]))
);


wait(1); // demo purposes

collist = dt << Get Column Names("String");
col_order = {"7", "8", "3", "4", "5", "6", "1", "2", "9"};
dt << Move Selected Columns(col_order);

Re: How to interchange columns using JSL?

UserID16644 — Mon, 11 Nov 2024 23:31:18 GMT

This works well. But just one question, is it also possible to move only the data inside the columns and not its headers? How is it done using JSL?

Re: How to interchange columns using JSL?

txnelson — Tue, 12 Nov 2024 02:27:00 GMT

You can either just change the Header names rather than moving the data, or you can actually move the data. See example below

names default to here(1);
dt =
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

// Move header is easier than moving all of the data
:weight << set name("new name");
:height << set name("weight");

// One way to move data
theHeights = :weight << get values;
theWeights = :new name << get values;
:new name << set name("height");

:weight << set values(theWeights);
:height << set values(theHeights);