Forum Discussion
Managing Relationship - data Not coming through
I have two seperate excell spreadsheets, both have the same reference number. When I manage the relationship between these two files, the second coulmn does not populate correctly and comes up as...
In at least 1 of your files the reference number should be unique.
You probably can't fix it at the source, but maybe you can use powerquery to transform the data to satisfy this requirement.