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.