topic Re: Bring Text file into QV with Transformation in QlikView

Bring Text file into QV with Transformation

regowins — Fri, 07 Feb 2014 16:09:51 GMT

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!

Re: Bring Text file into QV with Transformation

juleshartley — Fri, 07 Feb 2014 16:22:02 GMT

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

Re: Bring Text file into QV with Transformation

juleshartley — Fri, 07 Feb 2014 16:23:39 GMT

See here for further discussion

Re: Bring Text file into QV with Transformation

regowins — Fri, 07 Feb 2014 16:25:08 GMT

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

Re: Bring Text file into QV with Transformation

juleshartley — Fri, 07 Feb 2014 16:32:33 GMT

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.

Re: Bring Text file into QV with Transformation

regowins — Fri, 07 Feb 2014 16:37:39 GMT

Ok Where is the link?

Re: Bring Text file into QV with Transformation

marcus_sommer — Fri, 07 Feb 2014 16:45:18 GMT

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

Re: Bring Text file into QV with Transformation

regowins — Tue, 11 Feb 2014 15:32:06 GMT

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

Thanks.