topic Load excel file with need to filter records in QlikView https://community.qlik.com/t5/QlikView/Load-excel-file-with-need-to-filter-records/m-p/202222#M60011 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Trying to Load an excel file which contains two types of records with same format</P><P>First type is Record Type A = purchase order and Second type is Record Type B = Reception</P><P>If Purchase order is not received yet , Record Type B doesn't exist</P><P>Each record is recognized with a [Movement order number] and a [movement order line] has unique keys</P><P>In Record Type B , two fields are containing the [Purchase order number] and [Purchase order line] (movement order number and movement order line) from Record type A to link the reception with the purchase order.</P><P>My need is to load all Record Type B = All receptions (easy !) and Record type A when Movement order number and movement order line do not exist as purchase order number and purchase order line in Record type B = Purchase Orders not received yet.</P><P>Thanks in advance to help ...</P><P></P><P>Gerard from France , Bellegarde 45</P><P></P></BODY></HTML> Thu, 25 Nov 2010 16:47:49 GMT 2010-11-25T16:47:49Z Load excel file with need to filter records https://community.qlik.com/t5/QlikView/Load-excel-file-with-need-to-filter-records/m-p/202222#M60011 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Trying to Load an excel file which contains two types of records with same format</P><P>First type is Record Type A = purchase order and Second type is Record Type B = Reception</P><P>If Purchase order is not received yet , Record Type B doesn't exist</P><P>Each record is recognized with a [Movement order number] and a [movement order line] has unique keys</P><P>In Record Type B , two fields are containing the [Purchase order number] and [Purchase order line] (movement order number and movement order line) from Record type A to link the reception with the purchase order.</P><P>My need is to load all Record Type B = All receptions (easy !) and Record type A when Movement order number and movement order line do not exist as purchase order number and purchase order line in Record type B = Purchase Orders not received yet.</P><P>Thanks in advance to help ...</P><P></P><P>Gerard from France , Bellegarde 45</P><P></P></BODY></HTML> Thu, 25 Nov 2010 16:47:49 GMT https://community.qlik.com/t5/QlikView/Load-excel-file-with-need-to-filter-records/m-p/202222#M60011 2010-11-25T16:47:49Z