topic How to use Set Property() to make a custerm order for a column? in Discussions

How to use Set Property() to make a custerm order for a column?

AutoDormouse960 — Fri, 22 Mar 2024 07:34:25 GMT

Hi, Dears,

I have a Demo.jmp which includes 3 columns:

Column Name, Data Type

T, Character

Value,Numeric

SN,Characer

I'd like to make a custerm order on column "T" as "LT","RT","HT" ascending with the script below:

//dt = Open("Demo.jmp"); 
//please open Demo.jmp manually
dt = Current Data Table();
dt << Recode Column( :T, Update Properties( 1 ), Target Column( :T ));
:T <<Set Property( "Value Order",{"LT", "RT", "HT"});

Here is the error info, and I need your suggestion, thanks.

Name Unresolved: Update Properties in access or evaluation of 'Update Properties' , Update Properties( 1 ) /*###*/

Re: How to use Set Property() to make a custerm order for a column?

jthi — Fri, 22 Mar 2024 07:40:39 GMT

Do it interactively in JMP and get the script from enhanced log OR by using Copy Column Properties

Data Table("Demo"):T << Set Property(
	"Value Order",
	{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
	Use Locale Comparisons for Characters(0)}
);

Copy Column / Copy Column properties scripts usually require a bit modification (this is from Copy Column Properties)

Add Column Properties(
	Set Property(
		"Value Order",
		{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
		Use Locale Comparisons for Characters(0)}
	)
)