897608_zh-CN

liliconcom

如何在 JMP 脚本中使用变量进行自定义值排序？

大家好，

我正在尝试使用 JSL 在列中设置自定义值顺序。这是我对列表进行硬编码时有效的代码：

TestTable:Origin << Set Property(
"Value Order",
{Custom Order({"EU", "IND", "US", "JPN", "AU"}), Common Order(0)}
);

但是，当我尝试将列表作为变量传递时，它不起作用：

countriesOrder = {"EU", "IND", "US", "JPN", "AU"};
TestTable:Origin << Set Property(
"Value Order",
{Custom Order(countriesOrder), Common Order(0)}
);

My goal is to read the country order from an Excel file and use that list dynamically. But I can't find documentation on what Custom Order() accepts—whether it can take a variable or only a literal list.

自动化和脚本基础数据分析与建模回复：如何在 JMP 脚本中使用变量进行自定义值排序？

JMP 列表中的变量除非强制执行，否则不会被求值。试试这个

countriesOrder = {"EU", "IND", "US", "JPN", "AU"};
Eval(
	Eval Expr(
		TestTable:Origin << Set Property(
			"Value Order",
			{Custom Order( Expr( countriesOrder ) ), Common Order( 0 )}
		)
	)
);