topic load txt-file with fields in lines in QlikView

load txt-file with fields in lines

khag_hs — Tue, 22 Jul 2014 16:33:30 GMT

I have some Data in a txt-File, which content data-fields in lines.

Example:

[Data 1]

ABC=xyz-123

DEF= 1 2 3

GHI=a b c

[Data 2]

ABC=asd-456

DEF=4 5 6

GHI=def

I want to load the Data in a table like this:

Another point: different txt-files have different amounts of data-sets.

Any idea, how to load this data in QV?

Two examples of Text-Files are added.

Anonymous — Tue, 22 Jul 2014 16:37:40 GMT

You need a Generic load, which is explained by Henric in this Blog Post.

Tue, 22 Jul 2014 17:05:45 GMT

Use generic load or use FOR loops to transform the source data.

Tue, 22 Jul 2014 17:36:29 GMT

Hi Please find the attached application for reference.