BookmarkSubscribeSubscribe to RSS Feed

Re: How can I paste a data table with text mixed in the clipboard into the specified table?

txnelson

Super User

Joined:

Jun 22, 2012

Solution

You can always create a JMP data table from the R Square table you are referencing, and then save that table as a csv or txt or slsx file. to then be read into your VBA script.

Jim
lwx228

Frequent Contributor

Joined:

Aug 14, 2018


I have a table merge in my code, and I want to write R squared at this point.But that's not the main thing.


d3 = d1 << Join( With( d2 ), By Row Number, Output Table( "Joined Data" ) );




I'm used to VBA, so I haven't adjusted my thinking.thank Jim!

lwx228

Frequent Contributor

Joined:

Aug 14, 2018

2018-09-16_07-33-03.png

txnelson

Super User

Joined:

Jun 22, 2012

I am not quite sure what you are attempting to ask.  My thinking is that you have 2 lines that are attempting to serve the same purpose.  The first line uses a JMP Join Platform to add a data table to an already existing data table.  Is the second line attempting to replace values in the dt3 data table?

Jim
Highlighted
lwx228

Frequent Contributor

Joined:

Aug 14, 2018

Thank you, Jim, for your continued attention. Sorry, I haven't done this problem and it has been solved. This figure is the actual effect I got with the method provided by the gzmorgan0.


In the process, I combined multiple data tables, and then wrote the data of R square into a fixed empty cell, which can be accurately found in the VBA processing in the later stage.
Thanks again to the two experts!