cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
MDB9933
MDB9933
Level I

How do I combine two columns one character and one numeric?

Jul 1, 2022 09:25 AM (884 views)
 
0 Kudos
3 REPLIES 3
David_Burnham
Super User (Alumni) David_Burnham
Super User (Alumni)

Re: How do I combine two columns one character and one numeric?

Jul 1, 2022 09:34 AM (882 views)  |  Posted in reply to message from MDB9933 07-01-2022

You can select the two columns, right-click to create a new formula column:

 

David_Burnham_0-1656682422758.png

 

-Dave
0 Kudos
MDB9933
MDB9933
Level I

Re: How do I combine two columns one character and one numeric?

Jul 1, 2022 01:19 PM (865 views)  |  Posted in reply to message from David_Burnham 07-01-2022

I am trying to put the time column and Seed# column together and when I do what you suggest it messes up the time input (see Concatenate column). 

 

MDB9933_0-1656695821820.png

 

0 Kudos
txnelson
Super User txnelson
Super User

Re: How do I combine two columns one character and one numeric?

Jul 1, 2022 02:37 PM (860 views)  |  Posted in reply to message from MDB9933 07-01-2022

Your Time column is a JMP Time column, which is measured in the number of seconds since midnight.  Thereroe, you need to convert it to a meaningful/displayable value.  This formula does it pretty well.

format(time,"hr:m") || " " :seed #

"12:00 21"

Jim