Joining tables with different significant digitsI am trying to join a DOE table created Jmp with a table created in an external program and imported into Jmp. I've figured out that if I expand the format to 16 decimals that the data does not match. For example, the initial value used when creating the DOE table was something like 1.2, the DOE table value to 16 decimals is 1.2000...002, and the imported data is 1.2000...000.
Is there a way to make this just work? I suppose I could go into the DOE table and manually change every value...ugh. (Tried that for one line and it worked.)
Data TableDOERe: Joining tables with different significant digitsUse the Round() function or floor() function to truncate to the desired number of significant digits. Then you can join the tables.
Re: Joining tables with different significant digitsOk, that works. Guess I should write a script so here's a follow-on question:
I've got a script in work, but I end up with new columns with the rounded value. Is there any way I can copy the values in that formula column back to the original column? (I want to keep the properties of the original column as part of the DOE.)
There is a simple "copy data" command, but no "paste data".
Thanks,
Michael
