Hi-
Any ideas why PowerPivot would be recognising and ignoring special characters in one table but not another?
Let me give you some background. I have a supplier table with 2 fields; Child Name & Parent Name. The child name has instances of special characters e.g. there might be a record called ***Joe Bloggs and another called Joe Bloggs - PowerPivot is CORRECTLY not seeing this as a duplication but two distinct records.
This table is successfully linked with a number of others.
I now have the need to filter my analysis to the suppliers we have a lot of spend with. Using the same source as my supplier table above i created a new table and added an expenditure column. When I import this table to PowerPivot and try to establish the same relationships as before i get an error telling me i have duplicates. The duplicates appear to be due to the special characters......
Any ideas?
Any ideas why PowerPivot would be recognising and ignoring special characters in one table but not another?
Let me give you some background. I have a supplier table with 2 fields; Child Name & Parent Name. The child name has instances of special characters e.g. there might be a record called ***Joe Bloggs and another called Joe Bloggs - PowerPivot is CORRECTLY not seeing this as a duplication but two distinct records.
This table is successfully linked with a number of others.
I now have the need to filter my analysis to the suppliers we have a lot of spend with. Using the same source as my supplier table above i created a new table and added an expenditure column. When I import this table to PowerPivot and try to establish the same relationships as before i get an error telling me i have duplicates. The duplicates appear to be due to the special characters......
Any ideas?
