424819_en-US

liliconcom

data cleanup, merge data from 3 columns into one column

HI Newbie here, I need some help to merge the data from 3 columns into one column, the data were collected in different time and by different person, and in 3 columns, so there are some missing data, some matched, like this:

 

A  B  C  

1  1  

0      0

1      1

 

How do I merge the data in A, B, C columns into one column in JMP?

Thank you so much for helping!

Data TableRe: data cleanup, merge data from 3 columns into one column

How would you like to combine them? Sum of them? Concatenate them together? For example to sum them you could create new formula column with following formula:

Sum(:A, :B, :C)

To concatenate (character data), select all columns, right click on one of them and:

Or select all of them, Cols / Utilities / Combine Columns:

 

 

Re: data cleanup, merge data from 3 columns into one column

Are the columns numeric or character?

Given the above example, what is your expectation of what the final column will contain?

 

1

0

1

 

or

 

11

0 0

1 1

 

or

 

11

00

11

Re: data cleanup, merge data from 3 columns into one column

Thanks txnelson and jthi, the columns are character, I need them to be either 1 or 0, the data in the 3 columns are either match or missing, so I just need to aggregate them together. 

Much appreciated!!