topic Re: Move Selected Columns syntax error in JMP17 in Discussions

Move Selected Columns syntax error in JMP17

Pim — Thu, 08 Jun 2023 16:34:38 GMT

Dear community, maybe someone can help me out.

I have created an add-in in JMP16 in which part of the add-in is to move ~60 columns in the order I want.

For this, I use the

Move Selected Columns

syntax.

However, since I've installed JMP17, this syntax doesn't seem to work anymore. The columns now seem to be placed in a random order and not in the order I scripted.

The scripts looks like this (column names and amount of columns are simplified for this example):

dt << Move Selected Columns({ :"Column 1"n, :"Column 2"n, :"Column 3"n, :"Column 4"n, :"Column 5"n, :"Column 6"n });

However, the order I end up with may look like this: Column 2, Column 3, Column 6, Column 1, Column 5, Column 4

When looking at the Scripting index in JMP17, <Move Selected Columns> still seems to be the correct syntax. Has anyone else encountered this problem and maybe found a solution?

Re: Move Selected Columns syntax error in JMP17

Pim — Mon, 20 Feb 2023 07:02:45 GMT

Maybe I should add: Columns I try to order are a mix of Continuous data columns, Nominal data columns and columns with formulas.

(Although JMP16 didn't seem to mind this).

Re: Move Selected Columns syntax error in JMP17

Pim — Mon, 20 Feb 2023 08:28:49 GMT

I just found this topic that adresses the issue I have:

https://community.jmp.com/t5/Discussions/Any-idea-why-Move-Selected-Columns-works-with-a-list-was-changed/m-p/594187#M79806