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

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

MDB9933 — Fri, 01 Jul 2022 13:25:53 GMT

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

David_Burnham — Fri, 01 Jul 2022 13:34:12 GMT

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

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

MDB9933 — Fri, 01 Jul 2022 17:19:38 GMT

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).

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

txnelson — Fri, 01 Jul 2022 18:37:39 GMT

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"