Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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.