897608_zh-TW

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