So when I export large reports from my ERP they often look like this:
[blank row]
Page 1
Dates 1/1/XX to 1/30/XX
Doc Type: AA to AC
Header 1 Header 2 Header 3 Header 4 Header 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
Page 2
Dates 1/1/XX to 1/30/XX
Doc Type: AA to AC
Header 1 Header 2 Header 3 Header 4 Header 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
Data 1 Data 2 Data 3 Data 4 Data 5
It's really a report with hundreds or thousands of pages. They are always tab deliminated
My problem is when I load them to qlik,
A. they don't show up because my first row is actually blank, skipping the row doesn't seem to help. I'm assuming because qlik is still using my first row as the document layout which doesn't have any columns.
B. So I would really want the table to take it's shape from the first row with headers in it. Then I would want remove all rows with report headers and the field names in subsequent rows. My first column does have numerical values so maybe I could tell the load editor to ignore non-numerical values after the first row.
I think problem A is my biggest problem because I can't even get the data to load for now.
Any suggestions?
