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.
When you use Get Data to connect to an Excel sheet you can add a step that removes duplicates. Have you not done this?
Seriously try my check. You will see that there are duplicates.
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).