Forum Discussion
make one unique column from 2 columns
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 |
|
Hi Anonymous,
Based on my test, here we can add index column to make the two tables related in desktop.
- Get two tables imported in desktop.
- Edit Queries -> Add column -> Index column (from 0 by default). Both tables should be added the index column here.
- 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
1 Reply
Hi Anonymous,
Based on my test, here we can add index column to make the two tables related in desktop.
- Get two tables imported in desktop.
- Edit Queries -> Add column -> Index column (from 0 by default). Both tables should be added the index column here.
- 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