826492_zh-CN

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