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
eliyahu100
Level III

Concatenate tables columns with labels

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.eliyahu100_0-1594297856201.png

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

TIA

2 REPLIES 2
Highlighted
txnelson
Super User

Re: Concatenate tables columns with labels

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

Re: Concatenate tables columns with labels

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

Article Labels