I need to write a load script where the table looks like this
So What is happening here is,
The Item2 and Item3 have only one customer getting repeated over time. The Item2 has Cust3 and Item3 has Cust1.
So the final table in the data model will contain only those Items which have same customers repeated over times and discard the items which has different customers repeated over times like Item1 which has different customers associated with it.