Forum Discussion
Resolving Variations in Data - IE: Address Grouping
Hello, I’m working with a shipment data set and am looking for a solution to group slight variations in the data. For example, company name may vary between shipments, (ABC Co. vs. A.B.C. Company) o...
Where is your data source? Say for from SQL server, you can write a stored procedure to pre-process this kind of data. Or when you can click home -> edit queries -> Add Columns -> Column From Examples to conduct the conversion such as Ln to Lane and Co. to Company. Depends on the complexity of the conversion, you can need to add multiple columns to get what you want.
Hope it helps.
Eric Ji | Senior Business Intelligence Consultant
www.designmind.com