Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
qspringleaf
Level III

How To Summary Data and Join it in one row by Group

Kindly help to suggest "How To use script/formula to summary data and Join it in one row by Group?"  thanks a lot.

 

 

Table I  Table II
NameShift  NameShift
LilyJan  LilyJan/Jul/Oct
TomFeb  TomFeb/May/Dec
JohnMar  JohnMar/Jun/Sep
KevinApr  KevinApr/Aug/Nov
TomMay    
JohnJun    
LilyJul    
KevinAug    
JohnSep    
LilyOct    
KevinNov    
TomDec    
1 REPLY 1
Highlighted
Thierry_S
Level VI

Re: How To Summary Data and Join it in one row by Group

Hi,

Here is the manual way to do this:
1) Split Table 1 Column Shift by Name (Table > Split)
2) Transpose the resulting table (Table > Transpose)
3) Concatenate the columns containing the shift information: select all 3 columns, right-click on the column header > New Formula Column > Concatenate with comma -> Table 2
Note, you can opt to change the delimiter (",") in the formula editor with whatever character you wnat.
Best,

TS
Thierry R. Sornasse
Article Labels