Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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.

Highlighted
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

Highlighted
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().

Article Labels

    There are no labels assigned to this post.