https://community.qlik.com/t5/Member-Articles/Moving-QVD-Files-Between-Spaces-in-Qlik-Cloud-Using-a-Script/ta-p/2493709 <DIV class="flex-shrink-0 flex flex-col relative items-end"> <DIV> <DIV class="pt-0"> <DIV class="gizmo-bot-avatar flex h-8 w-8 items-center justify-center overflow-hidden rounded-full"> <DIV class="relative p-1 rounded-sm flex items-center justify-center bg-token-main-surface-primary text-token-text-primary h-8 w-8"><STRONG style="color: inherit; font-family: inherit; font-size: 24px;"><BR />Moving QVD Files Between Spaces in Qlik Cloud Using a Script</STRONG></DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex max-w-full flex-col flex-grow"> <DIV class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&amp;]:mt-5" dir="auto" data-message-author-role="assistant" data-message-id="ecf23919-edb6-4e37-a417-c789aefa7957" data-message-model-slug="gpt-4o-mini"> <DIV class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]"> <DIV class="markdown prose w-full break-words dark:prose-invert light"> <P>In Qlik Cloud, moving QVD files between different spaces is not a straightforward operation through the interface. However, with a simple loading script, you can automate the process and easily transfer multiple QVD files from one space to another.</P> <P>This method involves the creation of a Qlik script that loads QVD files from one location (space) and stores them into a different space. Below is a step-by-step guide to implementing this technique.</P> <H4><FONT color="#339966"><STRONG>Step 1 : Set up your Environment</STRONG></FONT></H4> <P>Before running the script, ensure that you have the necessary permissions and that both source and destination spaces are properly configured in Qlik Cloud.</P> <P>The script works by renaming the location of QVD files, loading them from the source space, and storing them in the target space.<BR /><BR /></P> <H3><STRONG>Moving QVD Files Between Spaces in Qlik Cloud Using a Script</STRONG></H3> <P>In Qlik Cloud, moving QVD files between different spaces is not a straightforward operation through the interface. However, with a simple loading script, you can automate the process and easily transfer multiple QVD files from one space to another.</P> <P>This method involves the creation of a Qlik script that loads QVD files from one location (space) and stores them into a different space. Below is a step-by-step guide to implementing this technique.</P> <H4><FONT color="#339966"><STRONG>Step 2 : Script explanation<BR /></STRONG></FONT></H4> <P><STRONG>1 : Define your files</STRONG></P> <P>We start by naming the QVD files that need to be moved. These names should correspond to the files stored in the source space.</P> <LI-CODE lang="markup">SET FileList= ‘File1,File2,File3’</LI-CODE> <P>This line initializes a variable FileList&nbsp;containing the names of the QVD files. You can list as many files as you want, separated by commas.</P> <P><STRONG>2 : Loop over the file list</STRONG></P> <P>The script uses a FOR loop to iterate over each table listed in the FileList. It splits the list using commas and processes each file one by one.</P> <LI-CODE lang="markup">FOR i = 1 TO SubStringCount('$(FileList)', ',' ) + 1 LET var = SubField('$(FileList)', ',', $(i));</LI-CODE> <DIV class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">&nbsp;</DIV> <P>This segment identifies each table in the list and assigns it to the variable var.</P> <P><STRONG>3 : Loop over the file list</STRONG></P> <P>For each table, the script defines the path of the QVD file in both the source and target spaces.</P> <LI-CODE lang="markup">LET oldQVD = 'lib://OLDSPACE:DataFiles/$(var).qvd'; LET newQVD = 'lib://NEWSPACE:DataFiles/$(var).qvd'; </LI-CODE> <DIV class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">&nbsp;</DIV> <P>Here, oldQVD is the path to the source QVD file, and newQVD is the new path in the target space. Make sure to adjust these paths to match your Qlik Cloud environment.</P> <P><STRONG>4 : Load and Store the Data</STRONG></P> <P>The script loads the data from the source space and stores it in the destination space.</P> <LI-CODE lang="markup">TRACE ‘Moving of the file from $(oldQVD) to $(newQVD)'; [$(var)]: LOAD * FROM [$(oldQVD)] (qvd); STORE [$(var)] INTO [$(newQVD)](qvd); DROP TABLE [$(var)]; NEXT EXIT SCRIPT;</LI-CODE> <DIV class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950">&nbsp;</DIV> <P>The TRACE&nbsp;command outputs information for monitoring the process.<BR />The LOAD statement loads the QVD file from the source location.<BR />The STORE command saves the data into the new QVD file in the target space.<BR />The DROP TABLE command removes the table from memory after storing it.<BR />Finally, the NEXT command&nbsp; is used to move to the next iteration in the FOR loop.</P> <P>After processing all the QVD files, the script exits.</P> <H4><FONT color="#339966"><STRONG>Step 3 : Execute the script</STRONG></FONT></H4> <P>Once you've adjusted the paths and files names, simply run the script in the Qlik Cloud environment. This will move the specified QVD files from the source space to the target space, one by one.</P> <DIV class="flex-shrink-0 flex flex-col relative items-end"> <DIV> <DIV class="pt-0"> <DIV class="gizmo-bot-avatar flex h-8 w-8 items-center justify-center overflow-hidden rounded-full"> <DIV class="relative p-1 rounded-sm flex items-center justify-center bg-token-main-surface-primary text-token-text-primary h-8 w-8">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex max-w-full flex-col flex-grow"> <DIV class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&amp;]:mt-5" dir="auto" data-message-author-role="assistant" data-message-id="c852a86a-87d6-456a-a3fb-ed5f50945004" data-message-model-slug="gpt-4o-mini"> <DIV class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]"> <DIV class="markdown prose w-full break-words dark:prose-invert light"> <P>Here’s the complete script you can use directly without having to copy-paste each section:</P> <LI-CODE lang="markup">SET FileList= ‘File1,File2,File3’ FOR i = 1 TO SubStringCount('$(FileList)', ',' ) + 1 LET var = SubField('$(FileList)', ',', $(i)); LET oldQVD = 'lib://OLDSPACE:DataFiles/$(var).qvd'; LET newQVD = 'lib://NEWSPACE:DataFiles/$(var).qvd'; TRACE ‘Moving of the file from $(oldQVD) to $(newQVD)'; [$(var)]: LOAD * FROM [$(oldQVD)] (qvd); STORE [$(var)] INTO [$(newQVD)](qvd); DROP TABLE [$(var)]; NEXT EXIT SCRIPT;</LI-CODE></DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <P><BR />Thank you for the reading.</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Cloud on the 20th november 2024</LI> </UL> Wed, 20 Nov 2024 16:20:26 GMT theoat 2024-11-20T16:20:26Z https://community.qlik.com/t5/Member-Articles/Moving-QVD-Files-Between-Spaces-in-Qlik-Cloud-Using-a-Script/ta-p/2493709 <P>Struggling to manage your QVD files across multiple spaces in Qlik Cloud? We’ve got a quick and efficient solution for you! With a simple loading script, you can automate the process of moving QVD files from one space to another — no manual export/import needed!</P> <P>In just a few lines of code, you’ll be able to:</P> <UL> <LI><STRONG>Easily transfer QVD files</STRONG> between spaces in Qlik Cloud</LI> <LI><STRONG>Automate the process</STRONG> for multiple files at once</LI> <LI><STRONG>Save time</STRONG> and streamline your workflow</LI> </UL> <P>Check out the full script and learn how to move your data quickly and effortlessly! <span class="lia-unicode-emoji" title=":rocket:">🚀</span></P> Wed, 20 Nov 2024 16:20:26 GMT https://community.qlik.com/t5/Member-Articles/Moving-QVD-Files-Between-Spaces-in-Qlik-Cloud-Using-a-Script/ta-p/2493709 theoat 2024-11-20T16:20:26Z