Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Conversion of table layout

I have the following table layout:

Article20110110
2011011720110120
Icecream15032
Hotdog200

And I would like to convert it into the following layout:

ArticleDate
Volume
Icecream2011011015
Icecream2011012032
Hotdog201101102

I have thousands of lines so i need som kind of automated algorithm to do this.

Thanks!

1 Solution

Accepted Solutions
Not applicable

Conversion of table layout

Solved it by myself through using the crosstable function in the load script, thanks anyway!

1 Reply
Not applicable

Conversion of table layout

Solved it by myself through using the crosstable function in the load script, thanks anyway!