Forum Discussion
Best practices for Creating unique customer id?
I get a flatfile from my online store with hundreds of orders. Some customers - the repeating ones - create a profile and purchase always from the same username. Others buy sporadically and don't bot...
Hi FalconOz
It is recommend to have a separate customer table as a dimension table. There should be a unique ID column in the customer table to distinguish every customer. The customers who don't bother to create a profile should also have unique IDs.
When cleaning data, you may try the Fuzzy merge feature. It is part of Merge Queries feature. You need a standard table in advance, then merge columns like address to it with fuzzy merge.
Best Regards,
Community Support Team _ Jing