Bring Text file into QV with Transformation

[regowins]

I have a text file that I need to bring into QlikView for processing and reporting.  Here is an image of what needs to be done along
with the example file attached.

Take the date (in red) in the header and add it as column repeated in the detail line (in blue).  Exclude the information surrounded
in black.  Please note the special character highlighted in yellow which signifies the end of the section.  The new date follows. 

Any ideas how I can accomplish this ?

Thanks!

[juleshartley]

I'm not clear what format this is in...  are you saying that you want to read data from a .txt?

[juleshartley]

See here for further discussion

[regowins]

yes, read data from the attached example .txt file.

[juleshartley]

This is not a very good format for querying and you will have to do a lot of transformation. I've put a link to another discussion, which is being moderated, but I would think you will have to do several passes at the data, possibly including loops. But it may not be possible to do what you are hoping.

[regowins]

Ok Where is the link?

[marcus_sommer]

To load the right rows is quite easy. You could define a header until the first field-names and other empty rows could be removed per where-clause. To catch the date is more complicated - see here approaches for a similar case:

Re: Loading spreadsheets with different formatting

Having problems with Creating new column in Document Load Wizard in QV

Further you could find good examples and explanation about loading unstructured data and the using from transformation-wizard in the book QlikView 11 for Developers - QlikView Book from Barry Harmsen.

- Marcus 

[regowins · Accepted solution]

The solution to this question has been resolved here Text file Transformation Error

Thanks.