- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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:
0011234 | 0123456 |
0123456 | 8765432 |
0987654 | 0 |
8765432 | 0 |
8866773 | 0987654 |
3456654 | 1234564 |
6875863 | 3456654 |
1234564 | 8866773 |
9860321 | 6875863 |
2350341 | 9860321 |
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Align matching values in two different columns
- Create a subset of the data, only with the 2nd column.
- Delete the second column from the 1st data table
- 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
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Align matching values in two different columns
- Create a subset of the data, only with the 2nd column.
- Delete the second column from the 1st data table
- 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