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.
Are these text values or real numbers?
I have both source files set to text
Add a Text.Upper to your import prior to your removal of duplicates.
You should also add that to your other table as well so that everything matches.
https://msdn.microsoft.com/en-us/library/mt260665.aspx
If you right-click the column in Query Editor you will get an option to Transform | UPPERCASE
