topic Re: how to merge columns in jmp in Discussions

how to merge columns in jmp

Dennisbur — Sat, 10 Jun 2023 23:58:31 GMT

Hello
I would like to merge column A and column B into one column.

Actually, I have found a solution to change the numeric type of column A and column B to character type

and after this, use "New Formula Column" >> "Concatenate."

My question is, without changing the numeric type, how can I merge column A and column B into column A&B?

Thank you

Dennis

Re: how to merge columns in jmp

jthi — Sat, 17 Dec 2022 21:32:57 GMT

You could use a formula which will handle the conversion from numbers to characters and then concatenate those

Char(:A) || Char(:B)

Edit:

Also remember to give kudos in wish list

Re: how to merge columns in jmp

Thierry_S — Sun, 18 Dec 2022 06:11:57 GMT

Hi,

If you want to keep all the columns as numeric, and the pattern of merging is the same, you could use the straightforward formula below:

1000 * :Column A + :Column B

Best,

Re: how to merge columns in jmp

Dennisbur — Sun, 18 Dec 2022 07:44:10 GMT

Hello,

Did you mean this is the formula?

Because if I used this formula, I received mathematical calculations and not merge columns

Re: how to merge columns in jmp

hogi — Sun, 18 Dec 2022 08:07:26 GMT

Too many brackets :)

Re: how to merge columns in jmp

txnelson — Sun, 18 Dec 2022 08:25:51 GMT

What @Thierry_S is showing, is that if you want to keep with numeric values, and have them ending up looking like the results from a concatenation with characters, you need to multiply the first number by 100 or 1000 whatever the number of digits (2 or 3) it needs to be displaced by to mimic the concatenation. Therefore, for your data table the formula would be

:Column 1 * 100 + :Column 2