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

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

Owen_Kim — Thu, 17 Oct 2019 02:19:31 GMT

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?

txnelson — Thu, 17 Oct 2019 03:49:17 GMT

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