Forum Discussion
Connect two tables
Good morning,
I'm new to power bi. I've seen a series of videos on youtube and now I'm getting my hands dirty.
I'm trying to link two tables.
A customer table, and a sales table.
I have a problem, in the sales table the only unique field is the customer's name. I don't have the client_id or the taxpayer number.
I try to link the two tables using the customer's name but I can't.
How can I solve?
PS- I used google translator to write this text
Thanks
Ricardo Sousa
RicardoSousa198 Well, the best practice is to use a unique key between the tables but it sounds like you don't have that. I don't know your data, but sometimes its possible to create a unique key column by appending columns together. Like Key Column = [Column1] & "|" & [Column2].
But, I don't think that's going to help in your case. You need better data is what it sounds like.
3 Replies
RicardoSousa198 The image shown indicates that the tables are linked successfully. Or was this a mock-up of what you want?
Hello Greg_Deckler
thank you very much for your answer
The image is my connection. The connection works.
As I have the connection made using the client's name, which is not the most correct, because there may be people with the same name, I would like to know if there is any way to make another connection.
What are the best practices in this case?RicardoSousa198 Well, the best practice is to use a unique key between the tables but it sounds like you don't have that. I don't know your data, but sometimes its possible to create a unique key column by appending columns together. Like Key Column = [Column1] & "|" & [Column2].
But, I don't think that's going to help in your case. You need better data is what it sounds like.
