BookmarkSubscribeRSS Feed
keyurkj

Community Member

Joined:

Jan 31, 2019

Copy a row cell and populate into column

Hello everyone,

I am novice with regards to scripting in JMP. I have a following task which I specifically want to use script to solve it. Any help would be appreciated

I am describing my question using the following table

Example 1   
NameAndrew1  
NoInformationdetailsCol.
1x1 
2xx2 
3 ....till 10xxx3

 

In the above example there are 10 entries

I want to select a particukar row ( in this case row 2); concatenate  and populate the last column for the 10 entries as Andrew1, thus the table would look like

Example 1   
NameAndrew1  
NoInformationdetailsCol.
1x1NameAndrew1
2xx2NameAndrew1
3 ....till 10xxx3

NameAndrew1

 

Thank you

1 REPLY
Highlighted
cwillden

Super User

Joined:

May 1, 2017

Re: Copy a row cell and populate into column

Hi @keyurkj 

Can you post an example table with multiple entries?  Based on what I'm seeing, your data is in a very unfriendly format for JMP.  Keep in mind, JMP is not a spreadsheet program like Excel.  On the surface, this feels like trying to coerce JMP to be like Excel.  If that's how the data comes, we can probably do some pre-processing to get the data in a better format.  That's why I'm asking to see a more thorough example.

-- Cameron Willden