Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

Article Labels

    There are no labels assigned to this post.