cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Due to global connectivity issues impacting AWS Services, users may experience unexpected errors while attempting to authorize JMP. Please try again later or contact support@jmp.com to be notified once all issues are resolved.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
jearls11
Level III

Add value from multiple rows to once cell

Hi folks,

I want to insert multiple values into one cell. I have manually done it in the screen grab so i want the value from row 1,2,3 to be joined together and added to 3 rows.
Not sure how to complete this, do i need more identifiers so it can join the code. sorry I cant share the dataset due to IP reasons but below is a snippet

jearls11_0-1670887113545.png

 

1 REPLY 1
KarenC
Super User (Alumni)

Re: Add value from multiple rows to once cell

You can use a formula....

 

If contains(Process RC 2 , "RC1") then concatenate("[", char(:blasmultiplier), "," , lag(-1, char(:blasmultiplier)), lag(-2, char(:blasmultiplier)) )

else lag(1, Column 59)

 

That is a rough rendition....hopefully enough for you to figure it out... 

Recommended Articles