topic Re: Binary Load in QlikView https://community.qlik.com/t5/QlikView/Binary-Load/m-p/342435#M702699 <HTML><HEAD></HEAD><BODY><P>I don't think that you can set constraints to the binary load directly (like a where clause in a LOAD).</P><P></P><P>If the creation of a different source file or usage of qvd's instead of a binary load is not an option,</P><P>I can only think of doing data model changes after the binary load, maybe using resident loads with a where clause and dropping the original tables.</P><P>You might also consider using a Macro to select your subset of data and then reduce the data after reload.</P></BODY></HTML> Tue, 10 Jul 2012 08:27:19 GMT swuehl 2012-07-10T08:27:19Z Binary Load https://community.qlik.com/t5/QlikView/Binary-Load/m-p/342434#M702698 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>I have a question:</P><P></P><P> I load data with the help of a binary load command. Is it possible to load just a special type<BR />(one selling area, couple of products, etc.) of the whole binary data model, so<BR />that the needed data model becomes smaller and the performance gets better.</P><P></P><P>Joachim</P></BODY></HTML> Tue, 10 Jul 2012 07:44:36 GMT https://community.qlik.com/t5/QlikView/Binary-Load/m-p/342434#M702698 2012-07-10T07:44:36Z Re: Binary Load https://community.qlik.com/t5/QlikView/Binary-Load/m-p/342435#M702699 <HTML><HEAD></HEAD><BODY><P>I don't think that you can set constraints to the binary load directly (like a where clause in a LOAD).</P><P></P><P>If the creation of a different source file or usage of qvd's instead of a binary load is not an option,</P><P>I can only think of doing data model changes after the binary load, maybe using resident loads with a where clause and dropping the original tables.</P><P>You might also consider using a Macro to select your subset of data and then reduce the data after reload.</P></BODY></HTML> Tue, 10 Jul 2012 08:27:19 GMT https://community.qlik.com/t5/QlikView/Binary-Load/m-p/342435#M702699 swuehl 2012-07-10T08:27:19Z