(Forgive me if this has been answered elsewhere)
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
Prescriber QVD:
1 Steve 55391
2 Aaron 55442
3 Kevin 55356
Territory
55391 West Metro
55442 Metro
55356 Out-State
Exceptions
1 Out-State
