Query to perform multiple task based on text in one field
Posted on 2015-02-24
This one seems complicated to me.
My company has different locations in different countries and each group has similar procedures and jobs. The customers we service are the same. However, each customer has a different format of their data. Like our customers we also have slightly different ways to manage the data.
However, the task of the "Corporate" side is to consolidate all of these locations under the same Customer Corporate umbrella. Therefore, we must compile the data and report it as ONE.
My Canada location does not use the Customer primarykey as their primary key. Therefore, there are a few cases where they have multiple Customer primary keys in the same record. They do this so they don't have to enter duplicates manually.
But in the Corporate side, we use the customer primary key as ours. I need to locate and separate these into multiple records as they should be.
This Reject field may or may not have multiple groups of text that start with "R0" and each one is separated with "/".
Reject can have the following
For those records that have multiple values in (reject) I need to create a duplicate record for all fields (15 different fields need to be copied) in that record set. However, I need those duplicate records to be separate by the multiple (Reject) values.