Forum Discussion
Solved
Relationships Issue
Hi All I have an issue which I can't seem to figure out what is causing it. I have pulled in two tables of customer related data of which a common relationship is the part number. I pulled o...
Oops, change COUNTROWS to COUNT.
No didn't know I could do that...I removed duplicates using excel. I will try this.
Before you remove duplicates, change the case to upper or lower for the whole column (assuming these "numbers" are actually text value alphanumeric codes rather than literal whole number values).