Forum Discussion
Customer table issue
Hello,
Trying to determine the best way to set up a customer table in my data model. I'm having issues with "many to many" which I don't normally get but I've added an element to the data model.
Very simply, the issue is that we have customers (distributors) who in turn sell to their customers. In certain channels, we think of these secondary customers still as "our" customers. So the customer table can easily look like this:
Customer ID Primary Customer Secondary Customer
C-0123 Big Inc John's Flower Co
C-0123 Big Inc Flower Power Inc
C-0123 Big Inc Plants and More
Obviously I have duplicates with the Customer ID and the Primary Customer. How best to create a master customer table (or tables) so that I don't get relationship issues as I try to join them to other tables? Thanks in advance.
2 Replies
Anonymous
What does your sales/transaction table have? If it has a Secondary Customer or Secondary Customer ID this should work. else create a customer dimension distinct name and ID. More I can suggest if I have idea how this table is used
Hi Anonymous ,
You could use DISTINCT() to create a one-to-many table.
According to your sample data, even though you have many-to-many relationships you could also get a unique value with multiple columns.
