Forum Discussion
Many to Many - No Duplicates?
Hey all, I'm working with a new data set that comes from Excel. It has one column for SKUs as a unique identifier. I am trying to link it to a second dataset that has SKUs but not as a unique ident...
I would try to first change the data types to text ( since they are an id of sorts i usually make all my id's text so there is no issues with accidentally combining the values as a value)
After that do trim then make sure you remove duplicates after the trim step in power query so trim would be on top.