Issue with concatenating and sort function

CoxPorcupine721 — Thu, 09 Jan 2025 20:10:00 GMT

I'm creating a table called "combinedTable" by concatenating two files and it saves just fine. But I would like to sort the concatenated table, but when I use the sort function it creates a new untitled table that pops up while saving the unsorted "combinedTable". What's wrong with my script?

<....

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

Re: Issue with concatenating and sort function

jthi — Thu, 09 Jan 2025 20:12:12 GMT

You are missing replace table

If you do sort in JMP table

You can see what JMP does from enhanced log

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

topic Issue with concatenating and sort function in Discussions

Issue with concatenating and sort function

Re: Issue with concatenating and sort function