cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
hacketkm
Level III

How can I combine 2 columns into one?


I would like to combine two columns into one. My data looks like the table below where "." represents missing data. I would like to make a column which resembles Column C.

Column AColumn B
.2013
.2014
2016.
2017.
Column C

2013

2014
2016
2017
1 ACCEPTED SOLUTION

Accepted Solutions
reeza
Level III

Re: How can I combine 2 columns into one?

I'm not familiar with JMP but isn't the first condition checking if the cell in A is blank versus missing?

SAS has a keyword, missing, does JMP have the same?

ie

If(is missing(:Column A) , :Column A, :Column B)

View solution in original post

3 REPLIES 3
hacketkm
Level III

Re: How can I combine 2 columns into one?

So far I have tried adding a new column with the formula: If( :Column A != "", :Column A, :Column B) but this doesn't work and I'm not sure why. It fills in the values from Column A but not from Column B.

reeza
Level III

Re: How can I combine 2 columns into one?

I'm not familiar with JMP but isn't the first condition checking if the cell in A is blank versus missing?

SAS has a keyword, missing, does JMP have the same?

ie

If(is missing(:Column A) , :Column A, :Column B)

hacketkm
Level III

Re: How can I combine 2 columns into one?

Thank you, I was able to get the formula to work using Is Missing().