Choose Language Hide Translation Bar
Highlighted
Owen_Kim
Level I

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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

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
Highlighted
txnelson
Super User

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

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

Article Labels

    There are no labels assigned to this post.