Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
khag_hs
Contributor II
Contributor II

load txt-file with fields in lines

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:

          

ABC

DEF

GHI

xyz-123

1 2 3

a b c

asd-456

4 5 6

def

  

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.

1 Solution

Accepted Solutions
Not applicable

Hi Please find the attached application for reference.

View solution in original post

3 Replies
Anonymous
Not applicable

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

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Not applicable

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

Not applicable

Hi Please find the attached application for reference.