topic Re: How to do residential loading without dropping the existing table. in QlikView https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102908#M756484 <HTML><HEAD></HEAD><BODY><P>Take a look here: <A href="https://community.qlik.com/qlik-blogpost/2819">Fact Table with Mixed Granularity</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 07 Sep 2018 06:59:14 GMT marcus_sommer 2018-09-07T06:59:14Z How to do residential loading without dropping the existing table. https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102905#M756479 <HTML><HEAD></HEAD><BODY><P>For example, I have a detail table that join two qvds, then want to get a summary table by group by .</P><P></P><P>Details:</P><P>Load</P><P>......</P><P>from QVD A</P><P>left join QVD B;</P><P></P><P>Summary:</P><P>Load</P><P>sum(field A),</P><P>sum(field B)</P><P>.....</P><P>Resident Details</P><P>Group by fieldC, fieldD;</P><P></P><P><SPAN style="font-size: 13.3333px;">Can I keep both Details and Summary tables in final data model? Thanks.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102905#M756479 yzhang88 2020-11-25T16:16:04Z Re: How to do residential loading without dropping the existing table. https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102906#M756481 <HTML><HEAD></HEAD><BODY><P>Yes, you can but make sure they are connected by only one column else you will have synthetic keys.</P></BODY></HTML> Thu, 06 Sep 2018 18:40:51 GMT https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102906#M756481 vamsee 2018-09-06T18:40:51Z Re: How to do residential loading without dropping the existing table. https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102907#M756482 <HTML><HEAD></HEAD><BODY><P>As Vamsee already mentioned you may keep both tables.</P><P>Just be sure you don't have more than one field with common name.</P><P></P><P>You may look at <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Qualify.htm">qualify</A> statement or can assign alias manually.</P></BODY></HTML> Thu, 06 Sep 2018 22:07:08 GMT https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102907#M756482 maxsheva 2018-09-06T22:07:08Z Re: How to do residential loading without dropping the existing table. https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102908#M756484 <HTML><HEAD></HEAD><BODY><P>Take a look here: <A href="https://community.qlik.com/qlik-blogpost/2819">Fact Table with Mixed Granularity</A></P><P></P><P>- Marcus</P></BODY></HTML> Fri, 07 Sep 2018 06:59:14 GMT https://community.qlik.com/t5/QlikView/How-to-do-residential-loading-without-dropping-the-existing/m-p/102908#M756484 marcus_sommer 2018-09-07T06:59:14Z