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.