Forum Discussion
See all rows in tabel visualisation
Anonymous - Well, it really shouldn't matter which one you choose. Keep the bridge table column and try changing those relationships to single direction versus Both.
Anonymous - OK, here is my theory. Buried in your list of ID's are "duplicates", something like the following:
A12_2KSPF3_A01
a12_2KSPF3_A01
That's what I am thinking. Something that DISTINCT isn't catching but the relationships see as duplicates. I know this has come up before. Let me see if I can research it.
Another possibility, trailing special characters or spaces. Make sure that in your Power Query that you use both Trim and Clean operations on your columns that eventually become the ID column.
Another option, create your bridge table in Power Query. Reference your original queries and create 2 new queries that only have that column in them. Use an Append query to union them. Then do a Remove duplicates operation.
Hi Greg_Deckler
So it is this that is causing my data to be repeated again and again, right?
As my data is currently repeating every single row for every single value of RunAmp. So if I manage to solve this, my data should be fine?
Thank you for your help.
Anonymous - I am very sure that if you solve the bridge table to have truly unique values so that in the relationships they show up as 1-* and not *-* then yes, there is a high probability that most of your headaches go away.
Hi Greg_Deckler
I tried to create your bridge table in Power Query. Reference your original queries and create 2 new queries that only have that column in them. Use an Append query to union them. Then do a Remove duplicates operation.
And it works! However, I get the errror message below and I cant seem to show the data.
Anonymous - Hooray! Task 1 accomplished, get an appropriate bridge table. Where are you getting that error? When you refresh or ?