Concatenate tables columns with labels

Question

I an trying to concatenate two tables with identical column names/

The thing is some of the columns have labels that are base on different values, since they came from two different sources.

for instance in one table Value Labels({1 = "Yes", 2 = "No"})

and for the second Value Labels({1 = "Yes", 0 = "No"})

so when concatenating i get two seperate No valuse, namely No:0 and No:2 as you could see in the following analysis.

Any suggestion how to force JMP to treat No as No?

TIA

HadleyMyers · Answer

You can find the details of how to use Recode in the JMP documentation here: https://www.jmp.com/support/help/en/15.1/index.shtml#page/jmp/recode-data.shtml

txnelson · Answer

You will need to Recode one of the tables to matching values before concatenating them.