Forum Discussion
Create Relationship
I'm tring to create the relationship between two "description", i'm 100% sure the 'description' under "masterCategory-OfficeTools' is unique. plus why 'description' and 'Category' had Sum symbol a...
In the query editor there is a remove duplicates function when you import your data from excel. Did you ever try using that?
Also in excel are you checking for dups on just the one column or the two that look highlighted?
The symbol next to the fields means they are numeric data type with a default aggregation.
If the MasterExport table is your fact table, try creating a new query by referencing it (right click "reference") and then add [Description] to the source line in the advanced editor or formula bar. Then trim and clean and then remove dups. Then try linking both original tables to this lookup table. You may have to change crossfiltering direction to both depending on how you want to work with the data.
If the MasterExport table is your fact table, try creating a new query by referencing it (right click "reference") and then add [Description] to the source line in the advanced editor or formula bar. Then trim and clean and then remove dups. Then try linking both original tables to this lookup table. You may have to change crossfiltering direction to both depending on how you want to work with the data.