topic How do I load this? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-load-this/m-p/469048#M699387 <HTML><HEAD></HEAD><BODY><P>Can someone point me in the direction of how I would go about loading the attached report? It is a very unusual invoice report format that I need to load into QlikView (it was exported out of an ERP system and has various levels of subtotals)</P><P>.</P><P>In the attached example spreadsheet data source, the string "Regular Invoices" string begins each invoice line item block</P><P>- To make matters more "interesting" the blocks can vary (for example, see lines 29-50 where a customer is purchasing more than 1 product)</P><P>Yellow-highlighted text is what I want to read in my load statement, I will ignore everything else</P><P></P><P>I really don't know where to start, so any advice is appreciated.</P></BODY></HTML> Thu, 27 Dec 2012 20:54:13 GMT 2012-12-27T20:54:13Z How do I load this? https://community.qlik.com/t5/QlikView/How-do-I-load-this/m-p/469048#M699387 <HTML><HEAD></HEAD><BODY><P>Can someone point me in the direction of how I would go about loading the attached report? It is a very unusual invoice report format that I need to load into QlikView (it was exported out of an ERP system and has various levels of subtotals)</P><P>.</P><P>In the attached example spreadsheet data source, the string "Regular Invoices" string begins each invoice line item block</P><P>- To make matters more "interesting" the blocks can vary (for example, see lines 29-50 where a customer is purchasing more than 1 product)</P><P>Yellow-highlighted text is what I want to read in my load statement, I will ignore everything else</P><P></P><P>I really don't know where to start, so any advice is appreciated.</P></BODY></HTML> Thu, 27 Dec 2012 20:54:13 GMT https://community.qlik.com/t5/QlikView/How-do-I-load-this/m-p/469048#M699387 2012-12-27T20:54:13Z