topic Re: Joining tables with different significant digits in Discussions

Joining tables with different significant digits

mfoster — Sat, 10 Jun 2023 23:41:18 GMT

I 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.)

Re: Joining tables with different significant digits

txnelson — Fri, 03 Dec 2021 21:48:35 GMT

Use 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 digits

mfoster — Mon, 06 Dec 2021 19:47:55 GMT

Ok, 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

Re: Joining tables with different significant digits

txnelson — Mon, 06 Dec 2021 20:21:24 GMT

interactively you can select all of the values in the column you want to copy, and then move your cursor to one of the selected cells and right click and select copy. Move to the column you want to paste in and right click on the first cell in the column and select paste.

Here is a simple script that will copy all of the values from one column to another.

Names Default To Here( 1 );
dt = Open( "$sample_data/big class.jmp" );
:age << set values( :weight << get values );

Re: Joining tables with different significant digits

jthi — Mon, 06 Dec 2021 20:40:30 GMT

You can also directly overwrite values with <<set each value, but I would suggest trying other options first, if you are just starting with scripting

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
:NPN1 << Set Each Value(Round(:NPN1));

Re: Joining tables with different significant digits

mfoster — Mon, 06 Dec 2021 22:11:47 GMT

Thanks. This is so much simpler than my complicated way with additional columns, tables and updates. Need to remember "Set".