762003_zh-TW

liliconcom

拆分錶而不按列拆分

我有一個看起來像這樣的數據表，

我想把它改成這樣。

我如何在 JSL 中執行此操作？我沒有參考列來分割它，但我知道奇數行將是我的第一個條目，偶數行將始終是我的第二個條目。

自動化和腳本編寫基礎資料分析與建模資料混合與清理視窗回覆：拆分錶而不按列拆分

使用您對奇數行和偶數行的了解來建立新列，並將其用作分割依據列

Names Default To Here(1);

dt = New Table("Untitled 2",
	Add Rows(8),
	Compress File When Saved(1),
	New Column("Column 1",
		Character,
		"Nominal",
		Set Values(
			{"Test1", "Test1", "Test1", "Test1", "Test1", "Test1", "Test1", "Test1"}
		)
	),
	New Column("Column 2",
		Character,
		"Nominal",
		Set Values(
			{"Test1", "Test1", "Test1", "Test1", "Test1", "Test1", "Test1", "Test1"}
		)
	),
	New Column("Column 3",
		Character,
		"Nominal",
		Set Values({"A", "1", "B", "2", "C", "3", "D", "4"})
	)
);

dt << New Column("By", Character, Nominal, Formula(
	If(Mod(Row(), 2),
		"Data 1";
	,
		"Data 2";
	);
));

dt_split = dt << Split(
	Split By(:By),
	Split(:Column 3),
	Output Table("Untitled 29.jmp"),
	Sort by Column Property
);