Discussion Board for collaboration on QlikView Scripting.
Hello QV Experts,
I have encountered quite challenging task. The issue is as follows:
I need to transform below table (in the script, I need qvd files with the below table and the new one)
As a result I need to create table as below:
I have more than 300 000 record in the first table so the problem may be also performance of the script execution
I would appreciate any help how to achieve the final result
The transformation looks like kind of "reverse crosstable", but nothing comes to my mind to make it
Thank you in advance for your support/comment
I think Generic Load is what you are looking for:
Use cases for Generic Load | Qlikview Cookbook
(html, codepage is 1252, embedded labels, table is @1);
SET t = 'T:';
for each i in 'A', 'B', 'C'
StartTime as $(i).StartTime,
EndTime as $(i).EndTime,
"EndTime-StartTime " as "$(i).EndTime-StartTime "
Where Task = '$(i)';
SET t = join (T);
Thanks Josefina, I think this is the right solution for my case
Do you have any idea how to improve the slow performance when I am joining all table after Generic Load?
Unfortunatelly I cannot avoid this as I need qvd file with all data
Is there any solution for that?