how to merge columns in jmpHello
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
Data TableRe: how to merge columns in jmp 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
Re: how to merge columns in jmpHi,
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
Re: how to merge columns in jmpHello,
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 jmpToo many brackets 
Re: how to merge columns in jmpWhat @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
