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: 
Browse apps to extend the software in the new JMP Marketplace
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 (2710 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 (2703 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 (2704 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