Align matching values in two different columns

Apurva14 — Mon, 01 Jul 2019 18:47:44 GMT

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

Re: Align matching values in two different columns

txnelson — Mon, 01 Jul 2019 22:24:05 GMT

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.

topic Align matching values in two different columns in Discussions

Align matching values in two different columns

Re: Align matching values in two different columns