cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EComment%20utiliser%20Set%20Property()%20pour%20passer%20une%20commande%20personnalis%C3%A9e%20pour%20une%20colonne%26nbsp%3B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EBonjour%2C%20mes%20chers%2C%3C%2FP%3E%3CP%3EJ'ai%20un%20Demo.jmp%20qui%20comprend%203%20colonnes%20%3A%3C%2FP%3E%3CP%3ENom%20de%20la%20colonne%2C%20type%20de%20donn%C3%A9es%3C%2FP%3E%3CP%3ET%2C%20Caract%C3%A8re%3C%2FP%3E%3CP%3EValeur%2C%20num%C3%A9rique%3C%2FP%3E%3CP%3ESN%2C%20personnage%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EJe%20souhaite%20passer%20une%20commande%20client%20sur%20la%20colonne%20%22T%22%20sous%20la%20forme%20%22LT%22%2C%20%22RT%22%2C%20%22HT%22%20en%20ordre%20croissant%20avec%20le%20script%20ci-dessous%26nbsp%3B%3A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2Fdt%20%3D%20Open(%22Demo.jmp%22)%3B%20%0A%2F%2Fplease%20open%20Demo.jmp%20manually%0Adt%20%3D%20Current%20Data%20Table()%3B%0Adt%20%26lt%3B%26lt%3B%20Recode%20Column(%20%3AT%2C%20Update%20Properties(%201%20)%2C%20Target%20Column(%20%3AT%20))%3B%0A%3AT%20%26lt%3B%3CSET%20property%3D%22%22%3E%3C%2FSET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3EHere%20is%20the%20error%20info%2C%20and%20I%20need%20your%20suggestion%2C%20thanks.%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3EName%20Unresolved%3A%20Update%20Properties%20in%20access%20or%20evaluation%20of%20'Update%20Properties'%20%2C%20Update%20Properties(%201%20)%20%2F*%23%23%23*%2F%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CLINGO-LABS%20id%3D%22lingo-labs-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EAutomatisation%20et%20scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eles%20fen%C3%AAtres%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FCODE%3E%3CLINGO-SUB%20id%3D%22lingo-sub-737571%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Comment%20utiliser%20Set%20Property()%20pour%20passer%20une%20commande%20client%20pour%20une%20colonne%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737571%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EFaites-le%20de%20mani%C3%A8re%20interactive%20dans%20JMP%20et%20r%C3%A9cup%C3%A9rez%20le%20script%20%C3%A0%20partir%20du%20journal%20am%C3%A9lior%C3%A9%20OU%20en%20utilisant%20Copier%20les%20propri%C3%A9t%C3%A9s%20de%20la%20colonne%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1711093143788.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1711093143788.png%22%20style%3D%22width%3A%20367px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62506i51C42F793A6D3728%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1711093143788.png%22%20alt%3D%22jthi_0-1711093143788.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1711093156396.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1711093156396.png%22%20style%3D%22width%3A%20907px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62507iA173F0A6258539B2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22jthi_1-1711093156396.png%22%20alt%3D%22jthi_1-1711093156396.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EData%20Table(%22Demo%22)%3AT%20%26lt%3B%26lt%3B%20Set%20Property(%0A%09%22Value%20Order%22%2C%0A%09%7BCustom%20Order(%7B%22LT%22%2C%20%22RT%22%2C%20%22HT%22%7D)%2C%20Common%20Order(0)%2C%20Numerical%20Order(0)%2C%0A%09Use%20Locale%20Comparisons%20for%20Characters(0)%7D%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ELes%20scripts%20de%20propri%C3%A9t%C3%A9s%20de%20copie%20de%20colonne%2Fcopie%20de%20colonne%20n%C3%A9cessitent%20g%C3%A9n%C3%A9ralement%20une%20l%C3%A9g%C3%A8re%20modification%20(cela%20provient%20des%20propri%C3%A9t%C3%A9s%20de%20copie%20de%20colonne)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EAdd%20Column%20Properties(%0A%09Set%20Property(%0A%09%09%22Value%20Order%22%2C%0A%09%09%7BCustom%20Order(%7B%22LT%22%2C%20%22RT%22%2C%20%22HT%22%7D)%2C%20Common%20Order(0)%2C%20Numerical%20Order(0)%2C%0A%09%09Use%20Locale%20Comparisons%20for%20Characters(0)%7D%0A%09)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

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

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 ) /*###*/

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

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

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

jthi_0-1711093143788.png

jthi_1-1711093156396.png

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)}
	)
)
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

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

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

jthi_0-1711093143788.png

jthi_1-1711093156396.png

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)}
	)
)
-Jarmo

Recommended Articles