topic Re: Any idea why Move Selected Columns works with a list was changed in JMP17? in Discussions

Any idea why Move Selected Columns works with a list was changed in JMP17?

jthi — Thu, 08 Jun 2023 16:40:26 GMT

Just noticed that my doesn't work with JMP17, or even worse it returns incorrect data. Issue is that JMP17 has changed how Move Selected Columns works with a list.

Names Default To Here(1);

dt = Open( "$SAMPLE_DATA/Big Class.jmp");
list = {"sex", "name"};

wait(1);
dt << Move Selected Columns(list, To Last);
show(JMP Version());

With this simple example you can see that JMP17 ignores the order of items in the list (or rather sorts alphabetically?)

JMP16:

JMP17:

I can figure out many ways to handle this, but I'm not really sure if I should have to

Names Default To Here(1);

dt = Open( "$SAMPLE_DATA/Big Class.jmp");

list = {"sex", "name", "age", "weight", "height"};
If(Num(Word(1, JMP Version(), ".")) < 17,
	dt << Move Selected Columns(list, To Last);
, // else
	first_col = Remove From(list, 1);
	dt << Move Selected Columns(first_col, To First);
	For Each({col}, list,
		Eval(EvalExpr(
			dt << Move Selected Columns({Expr(col)}, To Last);
		));
	);
);

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

FN — Fri, 27 Jan 2023 19:39:43 GMT

Joining the discussion to know if this is a bug.

This will probably break the functionality in the column organizer add-in.

https://community.jmp.com/t5/JMP-Add-Ins/MES-data-retrieval-add-in-Aspentech-IP-21-and-Osisoft-PI-Aveva/ta-p/540841

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

jthi — Sat, 28 Jan 2023 08:56:51 GMT

Also most likely breaks this (seems to have some bugs even with JMP16).

Might have to start adding limitation to add-ins that only specific versions work (will be a hassle to manage with multiple add-ins...).

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

FN — Wed, 01 Feb 2023 15:12:25 GMT

Have you contacted support to check if this change was intended?

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

jthi — Wed, 01 Feb 2023 16:18:03 GMT

I have but no response just yet.

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

DavidWhite — Wed, 01 Feb 2023 18:40:04 GMT

This was done to fix a crash. Unfortunately, it has proved to have unintended consequences.

It isn't sorting the columns by name, it's maintaining their original ordering. No matter how you order columns in the list given to Move Selected Columns(), the moved columns will maintain their original ordering relative to each other. So if you have a table with columns a, b, c, and d, in that order, then both Move Selected Columns({:b, :a}, To Last) and Move Selected Columns({:a, :b}, To Last) will result in the columns being ordered c, b, a, b.

As you discovered, an admittedly inconvenient workaround is to issue multiple Move Selected Columns commands. So to get the order c, d, b, a you can call Move Selected Columns({:b}, To Last) then Move Selected Columns({:a}, To Last).

This will be fixed.

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

Pim — Fri, 25 Aug 2023 12:54:37 GMT

Hi David,

I was wondering: has the column sorting issue been fixed?

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

NRW — Mon, 13 Nov 2023 22:42:48 GMT

Jarmo,

I just ran into this issue after recently upgrading to JMP 17. This is extremely frustrating since I was moving large column blocks (8 columns / block), with 24 total columns.

I wanted to try your solution, but still not totally understanding your "For Each" statement, even after reviewing scripting index. So is it basically looking at each element in list, {col}, and moving it to the end of the list?

Neil

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

jthi — Tue, 14 Nov 2023 05:46:27 GMT

It will move the items to end of list in order (so first one gets moved last as the first one -> ends up first in the end). If you want to do different kind of re-ordering (like re-ordering list of columns in place) the script would require some changes.

This might have been fixed in JMP17.2, at least I'm getting different result now with my initial script

Re: Any idea why Move Selected Columns works with a list was changed in JMP17?

NRW — Tue, 14 Nov 2023 12:07:06 GMT

Many thanks Jarmo!

I was able to get it working with this snippet as well.

list = {:a, :b, :c, :d};
lst_num = NItems(list);

For(kk = 1, kk < list_num, kk++,
		dt << Move Selected Columns({list[kk+1]}, After(list[kk]) );
);