topic Copy/Paste a table property (e.g. script) does not work in Discussions

Copy/Paste a table property (e.g. script) does not work

Georg — Sat, 10 Jun 2023 23:16:47 GMT

Often I just want to duplicate a table script (e.g. in table Big class) see screenshot.

Via context menu in table property area I first do Copy and in a second step I do Paste.

This in some case works (and an new script with the same Name and attached "2" is generated).

Most times it does not work, why?

What is the easiest way to duplicate a script?

My only Workaround is to copy the Content and the Name into a new script. It's possible, but many more Manual work.

Re: Copy/Paste a table property (e.g. script) does not work

Mark_Bailey — Thu, 23 Jul 2020 14:48:23 GMT

The command always works for me.

Right-click target table script and select Copy.
Right-click any table script and select Paste.

Re: Copy/Paste a table property (e.g. script) does not work

Georg — Fri, 24 Jul 2020 14:18:45 GMT

on my System (JMP Pro 15.0 or JMO 15.1) at Win10 it does not work.

To be more precise:

I open Big Class

Right click on "Distribution" -> Copy

Right click --> Paste --> Nothing changes!!!

I would have expected a script named "Distribution 2" to appear.

Copy works (because I can do paste into a new script window),

Paste probably also works (overwriting the current script with the same Name, so Nothing changes in the view).

But generating a copy of an existing script with a new Name does not work (i.e. replicating by adding " 2" to the Name doesn't work)

And the Miracle is, that it works sometimes.

Usually it works on the update script, and then a new one is created: "Update From Database 2"

and it works on table variables like "SQL", there "SQL 2" is generated.

Why doesn't it work Always?

For example see table generated by below script. For "SQL" it works, for "Oneway" it doesn't.

New SQL Query(
	Version( 130 ),
	Connection( "JMP" ),
	JMP Tables(
		["Big Class" => "$SAMPLE_DATA\Big Class.jmp"
		]
	),
	QueryName( "SQLQuery1" ),
	Select(
		Column( "name", "t1" ),
		Column(
			"age",
			"t1",
			Analysis Type( "Ordinal" ),
			Numeric Format( "Fixed Dec", "0", "NO", "" )
		),
		Column( "sex", "t1" ),
		Column( "height", "t1", Numeric Format( "Fixed Dec", "0", "NO", "" ) ),
		Column( "weight", "t1", Numeric Format( "Fixed Dec", "0", "NO", "" ) )
	),
	From( Table( "Big Class", Alias( "t1" ) ) ),
	Where(
		In List(
			Column( "sex", "t1" ),
			{"M"},
			UI( SelectListFilter( ListBox, Base( "Categorical" ) ) )
		)
	)
) << Run

Re: Copy/Paste a table property (e.g. script) does not work

Mark_Bailey — Fri, 24 Jul 2020 14:23:03 GMT

I suggest that you contact JMP Technical Support (support@jmp.com) about this problem. It always works for me so I have no clue about it failing to work for you.

Re: Copy/Paste a table property (e.g. script) does not work

Ake — Thu, 26 Jan 2023 10:13:57 GMT

I have the same problem! Mostly it copies the script between tables as expected, but sometimes not, so I have to make a new script with the same name and content in the new table. I have no idea what makes it work or not. Running jmp 16.0.0.