I would like to develop a script which converts the rows into columns dynamically
Since the data is huge the Cross Table is not the optimized way and the Customer don't want the same thing in the layout by Pivot.
Attaching a sample data and the kind of output needed for your kind reference.
Thanks & Regards
Solved! Go to Solution.
Jebamalai Dass wrote:
Since the data is huge the Cross Table is not the optimized way
Have you tested this assertion? The cross table operation converts the data into a proper fact table that will perform better than the original cross table and will greatly simplify the dimensions and expressions in the front end.
While you could achieve this manually, I very much doubt that what you do will outperform the QV crosstable function.
I think jontydkpi is right. In addition to them it might be helpful to split the crosstable-loadings in cases that there isn't enough RAM (it shouldn't be swapped into the virtual RAM) and/or to use incremental loads. Here you find various links to them: Advanced topics for creating a qlik datamodel
You probably ran out of memory - what makes you think that you can do it using less memory? This is a function of your data set and server RAM. You may have to reduce the one or increase the other.
But perhaps you should post the code that your tried. Please include the field names (ie not LOAD *) for diagnostic purposes.