nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Concatenate Multiple Data Tables [SOLVED]

mad

I have 605 data files I need to concatenate after filtering out the data I don't need from each file. Looping through each file, deleting the rows I don't need, concatenating the current file to the first file, then closing the current file works fine for the first 10+ files but gets exponentially slower with each additional file. Any suggestions?

I have noticed that each time a file is concatenated the source script gets added to the data table, could this be what is slowing things down? Is there a way to prevent this or delete them?

Message was edited by: MAD

Accepted answers

All comments

mad

Each time a file is opened and after each concatenation operation add:

dt << Delete Table Property( "Source" );

This dramatically improved the speed.

chungwei

what version of JMP are you running ?

mad

JMP 8.0

chungwei

I think this was fixed in 8.0.1.