0 Replies Latest reply: Dec 27, 2012 3:54 PM by Julie Stephens RSS

    How do I load this?

      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)

      .

      In the attached example spreadsheet data source, the string "Regular Invoices" string begins each invoice line item block

      - To make matters more "interesting" the blocks can vary (for example, see lines 29-50 where a customer is purchasing more than 1 product)

      Yellow-highlighted text is what I want to read in my load statement, I will ignore everything else

       

      I really don't know where to start, so any advice is appreciated.