topic ApplyMap from Two QVDs in QlikView https://community.qlik.com/t5/QlikView/ApplyMap-from-Two-QVDs/m-p/210803#M65245 <HTML><HEAD></HEAD><BODY><P>(Forgive me if this has been answered elsewhere)</P><P>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.</P><P>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.</P><P>Here is some sample data. Thanks for any suggestions</P><P>Prescriber QVD:</P><P>1 Steve 55391</P><P>2 Aaron 55442</P><P>3 Kevin 55356</P><P></P><P>Territory</P><P>55391 West Metro</P><P>55442 Metro</P><P>55356 Out-State</P><P></P><P>Exceptions</P><P>1 Out-State</P><P></P></BODY></HTML> Thu, 10 Feb 2011 16:59:23 GMT 2011-02-10T16:59:23Z ApplyMap from Two QVDs https://community.qlik.com/t5/QlikView/ApplyMap-from-Two-QVDs/m-p/210803#M65245 <HTML><HEAD></HEAD><BODY><P>(Forgive me if this has been answered elsewhere)</P><P>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.</P><P>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.</P><P>Here is some sample data. Thanks for any suggestions</P><P>Prescriber QVD:</P><P>1 Steve 55391</P><P>2 Aaron 55442</P><P>3 Kevin 55356</P><P></P><P>Territory</P><P>55391 West Metro</P><P>55442 Metro</P><P>55356 Out-State</P><P></P><P>Exceptions</P><P>1 Out-State</P><P></P></BODY></HTML> Thu, 10 Feb 2011 16:59:23 GMT https://community.qlik.com/t5/QlikView/ApplyMap-from-Two-QVDs/m-p/210803#M65245 2011-02-10T16:59:23Z