topic Re: I cant move newly created columns to specific locations in Discussions

I cant move newly created columns to specific locations

CrownofTears — Fri, 11 Aug 2023 19:47:13 GMT

I cant make my code work. I am trying to move some newly created columns to specific locations but I get the next error:

"Unrecognized key word"

Do you guys have any ideas of whats wrong here?

ColDelta=(ColNum-2)/2;
ColStart=4;

For(k=1, k<=ColDelta, k++,
	
	TabData << Move Selected Columns(
		Column (ColNum+k), after(Column(ColStart))
	);
	ColStart=ColStart+3;
	
	
);

Re: I cant move newly created columns to specific locations

mmarchandTSI — Fri, 11 Aug 2023 20:22:12 GMT

Try adding curly braces, like this:

ColDelta=(ColNum-2)/2;
ColStart=4;

For(k=1, k<=ColDelta, k++,
	
	TabData << Move Selected Columns(
		{Column (ColNum+k)}, after(Column(ColStart))
	);
	ColStart=ColStart+3;
	
	
);

Re: I cant move newly created columns to specific locations

CrownofTears — Fri, 11 Aug 2023 22:18:11 GMT

Perfect! It worked perfectly. Do you have an explanation on why or when I should use the curly braces?

Re: I cant move newly created columns to specific locations

mmarchandTSI — Mon, 14 Aug 2023 13:00:35 GMT

Well, kind of. I tried them, because it can take a list of columns. In this case, it seems to want even a single column in list format.

Re: I cant move newly created columns to specific locations

jthi — Mon, 14 Aug 2023 14:27:00 GMT

You might find syntax information sometimes from JMP Help Scripting Guide > Data Tables > Work with Columns > Rearrange and Move Columns or JSL Syntax Reference (can be found from JMP Documentation page)