Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to store qvds based on each single day. I have the data In db as
Id, start, end 1, 9/1/2023, 9/30/2022
The above record was actually stored as one record in db but the record was available for 30 days. So in general I need 30 qvds with same record showing up. I was able to get the records seperated out but need help in storing the qvds using loop instead of manually doing the work.
Please provide your thoughts. Any help is highly appreciated!!
Hi,
You can do it by looping in to the field data.
data:
load * inline [
data,ID
10-Oct-23 10:22:12 AM,1
10-Oct-23 10:22:12 AM,2
10-Oct-23 10:21:55 AM,3
];
FOR Each i in FieldValueList('data')
Final:
LOAD
*
FROM [<path>];
STORE Final into Path\FinalQVD.QVD;
drop Table Final;
NEXT i
DROP Table data;
exit Script;
store the table within the loop
There are some example script patterns for separating QVDs by date in this post:
https://qlikviewcookbook.com/2022/03/how-to-segment-qvd-files/
-Rob