Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Please find the attached application for reference.
You need a Generic load, which is explained by Henric in this Blog Post.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic
Use generic load or use FOR loops to transform the source data.
Hi Please find the attached application for reference.