229433_en-US

liliconcom

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?

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