cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Apurva14
Level II

Align matching values in two different columns

Hi all ! 

I had a basic question of how can align the same numeric value in two different columns.

For example: 

 

00112340123456
01234568765432
09876540
87654320
88667730987654
34566541234564
68758633456654
12345648866773
98603216875863
23503419860321

 

I want the values to match each other and if they do not match they should be still in the table 

 

Like in the above examples there is no matching value 0011234... but it should still be in the output table with a blank in front of it if it doesn't match ... 

 

Thank you !! 

@JMP @community 

 

AD14
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Align matching values in two different columns

  1. Create a subset of the data, only with the 2nd column.
  2. Delete the second column from the 1st data table
  3. Join table 1 with table 2, matching column 1 from the first table to the column in the second table. Make sure you indicate to keep all data from both tables.
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Align matching values in two different columns

  1. Create a subset of the data, only with the 2nd column.
  2. Delete the second column from the 1st data table
  3. Join table 1 with table 2, matching column 1 from the first table to the column in the second table. Make sure you indicate to keep all data from both tables.
Jim