Copy a row cell and populate into columnHello 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 | | | |
| Name | Andrew1 | | |
| No | Information | details | Col. |
| 1 | x | 1 | |
| 2 | xx | 2 | |
| 3 ....till 10 | xxx | 3 | |
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 | | | |
| Name | Andrew1 | | |
| No | Information | details | Col. |
| 1 | x | 1 | NameAndrew1 |
| 2 | xx | 2 | NameAndrew1 |
| 3 ....till 10 | xxx | 3 | NameAndrew1 |
Thank you
Re: Copy a row cell and populate into columnHi @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.