how to merge columns in jmp

[#1]

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

[#2 · Accepted solution]

 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 make NewFormulaColumn/Character more flexible 

[#3]

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,

TS

[#4]

Hello,

Did you mean this is the formula?

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

[#5]

Too many brackets :)

[#6]

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