topic Crosstable and orphan records in QlikView https://community.qlik.com/t5/QlikView/Crosstable-and-orphan-records/m-p/656393#M675570 <HTML><HEAD></HEAD><BODY><P>Experts,</P><P></P><P> I was trying to load a qvd file with a cross table transformation , it created so many orphan tables.</P><P>The solution was to put a where clause 1=1.</P><P></P><P>I was wondering why its creating orphan tables and why its not happening with the WHERE clause?</P><P></P><P>Thanks,</P><P>AP</P></BODY></HTML> Thu, 10 Jul 2014 22:00:03 GMT 2014-07-10T22:00:03Z Crosstable and orphan records https://community.qlik.com/t5/QlikView/Crosstable-and-orphan-records/m-p/656393#M675570 <HTML><HEAD></HEAD><BODY><P>Experts,</P><P></P><P> I was trying to load a qvd file with a cross table transformation , it created so many orphan tables.</P><P>The solution was to put a where clause 1=1.</P><P></P><P>I was wondering why its creating orphan tables and why its not happening with the WHERE clause?</P><P></P><P>Thanks,</P><P>AP</P></BODY></HTML> Thu, 10 Jul 2014 22:00:03 GMT https://community.qlik.com/t5/QlikView/Crosstable-and-orphan-records/m-p/656393#M675570 2014-07-10T22:00:03Z Re: Crosstable and orphan records https://community.qlik.com/t5/QlikView/Crosstable-and-orphan-records/m-p/656394#M675571 <HTML><HEAD></HEAD><BODY><P>This orphan happens when you make a crosstable load in an optimized load.</P><P>Using the "Where 1=1" as you comment, makes the load of the qvd no longer optimized, fixing the problem. Any where clause is going to be enough to avoid the orphan problem.</P></BODY></HTML> Tue, 30 Jan 2018 17:16:49 GMT https://community.qlik.com/t5/QlikView/Crosstable-and-orphan-records/m-p/656394#M675571 chris3669 2018-01-30T17:16:49Z