Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

1 Reply
Not applicable
Author

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