Choose Language Hide Translation Bar
txnelson
Super User

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

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

View solution in original post

Highlighted
lwx228
Level VII

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


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!

Highlighted
lwx228
Level VII

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

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

Highlighted
txnelson
Super User

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

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
Level VII

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

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!
Article Labels

    There are no labels assigned to this post.