Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
jasongao
Level II

How to combine two columns (with missing data)?

got a table with missing data like this:

Column1Column2
1
5
7
3

 

Need to combine it it to one column

 

Column3
1
5
7
3

 

I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? 

Thanks!

 

1 REPLY 1
Highlighted
jasongao
Level II

Re: How to combine two columns (with missing data)?

OK. I figured out. I need to use sum() instead of +.

Article Labels

    There are no labels assigned to this post.