826492_zh-TW

liliconcom

連接和排序功能的問題

我透過連接兩個檔案來建立一個名為「combinedTable」的表，它保存得很好。但我想對串聯表進行排序，但是當我使用排序函數時，它會建立一個新的無標題表，該表會在儲存未排序的「combinedTable」時彈出。我的腳本出了什麼問題？

<....

extractLast9Chars = Function({filename}, 

	Substr(filename, Length(filename) - 12, 11)
);

// Create a dictionary to store files by their last 9 characters
fileDict = Associative Array();

// Populate the dictionary with files from the first folder
For(i = 1, i <= N Items(files1), i++,
	last9 = extractLast9Chars(files1[i]);
	fileDict[last9] = folder1 || "/" || files1[i];
);


// Check for matching files in the second folder and combine them
For(j = 1, j <= N Items(files2), j++,
	last9 = extractLast9Chars(files2[j]);
	If(Contains(fileDict, last9), 
// Open the files
		file1 = Open(fileDict[last9]);
		file2 = Open(folder2 || "/" || files2[j]);

// Combine the data tables
		combinedTable = Concatenate(file1, file2);
		combinedTable << select where(Col Min(Row(), :lot, :wfr, :site) < Row()) << delete rows;
		combinedTable << sort(By(:wfr, :Site));


//save table with new name in existing foler
		newTableName = files2[j] || "_combined";
		filePath = "C:\temp\66k_Combined\" || newTableName;
		combinedTable << save(filePath);

// Close the individual files
		Close(file1, NoSave);
		Close(file2, NoSave);
		Close(combinedTable, NoSave);
	);
);

>

自動化和腳本編寫回覆：連接和排序功能的問題

您缺少替換錶

如果您在 JMP 表中進行排序

你可以從增強日誌中看到JMP做了什麼

// Sort data table
Data Table("Big Class") << Sort(By(:height), Replace Table, Order(Ascending));