https://community.qlik.com/t5/Data-Movement-Streaming/Creation-of-Partitioned-QVD-files/m-p/2078500#M1059 <P>Hi,</P> <P>&nbsp;</P> <P>You can try to loop over type field, like :</P> <LI-CODE lang="markup">For each vType in FieldValueList('type') TMP: NoConcatenate Load * Resident t1 Where type = '$(vType)' ; Store TMP into QVD_$(vType).qvd; Drop table TMP; next vType</LI-CODE> Wed, 31 May 2023 16:13:34 GMT Aurelien_Martinez 2023-05-31T16:13:34Z https://community.qlik.com/t5/Data-Movement-Streaming/Creation-of-Partitioned-QVD-files/m-p/2078106#M1053 <P>Hi,<BR />i have 72 million records in a table t1 which i want to partition based on a field 'type' and store as partitioned qvd files to load and create sheets.</P> <P>How can i do this?<BR />Thanks in advance!</P> Wed, 19 Mar 2025 23:04:08 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Creation-of-Partitioned-QVD-files/m-p/2078106#M1053 Uma7 2025-03-19T23:04:08Z https://community.qlik.com/t5/Data-Movement-Streaming/Creation-of-Partitioned-QVD-files/m-p/2078500#M1059 <P>Hi,</P> <P>&nbsp;</P> <P>You can try to loop over type field, like :</P> <LI-CODE lang="markup">For each vType in FieldValueList('type') TMP: NoConcatenate Load * Resident t1 Where type = '$(vType)' ; Store TMP into QVD_$(vType).qvd; Drop table TMP; next vType</LI-CODE> Wed, 31 May 2023 16:13:34 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Creation-of-Partitioned-QVD-files/m-p/2078500#M1059 Aurelien_Martinez 2023-05-31T16:13:34Z