I have two QVDs: one contains prescriber data and their dispenses; the other contains zip codes and sales territories. They join on zip code. I have a select population of prescribers whose terrritory is not the one mapped to their zip code. I want to overwrite the terrritory mapping resulting from the joining of the QVDs. The business maintains a list of prescriber ids and their new territory.
Do I need to create a composite QVD from the two initial QVDs so I can apply a map to overwrite the data? Is there another means to do this? I don't have much experience using resident tables but it looked like they might offer a solution.
Here is some sample data. Thanks for any suggestions
