make one unique column from 2 columns

[Anonymous]

Hi,

I have 2 tables. one with telephone records and one with mail records.

The names in both tables are the same but in table one is written backwards.

how can i create a unique id for both so i can make a dashboard. Do i have to make  a table with both names and search for difference or something else. Please help

Table 1 Telephone records	Table 2 Mail records	Table 3 Create Unique Id
Jason Kay	Kay Jason
Glenn Ruud	Ruud Glenn
Miranda van der Schaap	van der Schaap Miranda
David Jones	Jones David
El Khaled Bilal	Bilal el Khaled

[Anonymous · Accepted solution]

Hi @Anonymous,

Based on my test, here we can add index column to make the two tables related in desktop.

1. Get two tables imported in desktop.
2. Edit Queries ->  Add column -> Index column (from 0 by default). Both tables should be added the index column here.
3. Create relationship between Table1 and Table2 based on Index column, and create report using fields of the two tables.

Alternatively, we can merge the two tables as a new table after performing the first two steps, expand the required columns and create report using field of the merged table.

 

For more information, please refer to the pbix as attached.

Regards,
Lydia