User Community
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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

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

How do I concatenate some rows to new one including character with JMP formula?

Oct 16, 2019 10:19 PM (4177 views)

I want to concatenate some rows to new one as below.

 

Column X, Column Y

 

--> New Column : Column X_Column Y

 

Can I use JMP formula to merge like this?

 

One additional question is when I add new column based on some formula, can I take JMP script for the data table containing formula column?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

Re: How do I concatenate some rows to new one including character with JMP formula?

Oct 16, 2019 11:49 PM (4170 views)  |  Posted in reply to message from Owen_Kim 10-16-2019

You can simplily create a new character column, and use the following formula to concatenate you columns into the new column.

char(:columnX) || "_" || char(:columY)

You need to read the Using JMP documentation

     Help==>Books==>Using JMP

Jim

View solution in original post

1 REPLY 1
txnelson
Super User txnelson
Super User
Solution

Re: How do I concatenate some rows to new one including character with JMP formula?

Oct 16, 2019 11:49 PM (4171 views)  |  Posted in reply to message from Owen_Kim 10-16-2019

You can simplily create a new character column, and use the following formula to concatenate you columns into the new column.

char(:columnX) || "_" || char(:columY)

You need to read the Using JMP documentation

     Help==>Books==>Using JMP

Jim

Recommended Articles