Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

Tags (1)
Community Browser