Forum Discussion
How can i create relationship between two differt tables from 2 data sources
ramie Super difficult to say without showing us some sample data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg_Deckler ,
I already searched in the forum but not found anything. In simple terms i have 2 tables from 2 different datasources. I tried to create relationship between those 2 tables using append in power query but not happend, values are not matched correctly.
2 tables have 1 same cloumn but values or description might not same, i applied split function to make the column similar but finally data missmatching is happend.
if not clear let me know
Please i need help on this.
Thanks in advance
this is how both columns looks like in both tables, how can i create relationship.