You can perform a join between the
data set to get the desired output. However, a join creates duplicate data rows for all the customers in the data set. For example, if a customer with ID
has credit scores
, a join creates three data rows for the credit scores of the customer.