https://community.qlik.com/t5/App-Development/Splitting-a-qvd-file/m-p/2478337#M100461 <P>Hello,</P> <P>I want to splitt the file xxx according to the values from this table:</P> <P>&nbsp;</P> <DIV>MANDT_AGS:</DIV> <DIV>load * inline [</DIV> <DIV>Mandant</DIV> <DIV>000</DIV> <DIV>002</DIV> <DIV>003</DIV> <DIV>090</DIV> <DIV>101</DIV> <DIV>103</DIV> <DIV>108</DIV> <DIV>114</DIV> <DIV>119</DIV> <DIV>133</DIV> <DIV>148</DIV> <DIV>153</DIV> <DIV>160</DIV> <DIV>167</DIV> <DIV>178</DIV> <DIV>197</DIV> <DIV>294</DIV> <DIV>300</DIV> <DIV>301</DIV> <DIV>304</DIV> <DIV>305</DIV> <DIV>308</DIV> <DIV>340</DIV> <DIV>350</DIV> <DIV>351</DIV> <DIV>366</DIV> <DIV>375</DIV> <DIV>515</DIV> <DIV>550</DIV> <DIV>555</DIV> <DIV>585</DIV> <DIV>600</DIV> <DIV>628</DIV> <DIV>644</DIV> <DIV>650</DIV> <DIV>710</DIV> <DIV>800</DIV> <DIV>850</DIV> <DIV>860</DIV> <DIV>866</DIV> <DIV>900</DIV> <DIV>998</DIV> <DIV>999</DIV> <DIV>];</DIV> <DIV>&nbsp;</DIV> <DIV><SPAN> For j = 0 to NoOfRows('MANDT_AGS') - 1</SPAN></DIV> <DIV><SPAN> set vMandt =;</SPAN></DIV> <DIV><SPAN> &nbsp; &nbsp; let vMandt = text(Peek('Mandant', $(j), 'MANDT_AGS'));</SPAN></DIV> <DIV><SPAN> trace vMandt $(vMandt); </SPAN></DIV> <DIV><SPAN> [$(vMandt)]:</SPAN></DIV> <DIV><SPAN> //wir splitten Daten nach Mandant</SPAN></DIV> <DIV><SPAN> NoConcatenate </SPAN></DIV> <DIV><SPAN> LOAD * </SPAN></DIV> <DIV><SPAN> from [..\DATA\00-HP1-T501T.qvd](qvd)</SPAN></DIV> <DIV><SPAN> WHERE text(MANDT) = $(vMandt);</SPAN></DIV> <DIV><SPAN> if NoOfRows('[$(vMandt)]') &gt; 0&nbsp; then </SPAN></DIV> <DIV><SPAN> STORE [$(vMandt)] into [..\DATA\SPLITTING\00-HP1-T501T-$(vMandt).qvd](qvd);</SPAN></DIV> <DIV><SPAN> drop Tables [$(vMandt)];</SPAN></DIV> <DIV><SPAN> ELSE</SPAN></DIV> <DIV><SPAN> drop tables [$(vMandt)];</SPAN></DIV> <DIV><SPAN> ENDIF;</SPAN></DIV> <DIV>&nbsp; NEXT j;</DIV> <DIV>EXIT SCRIPT;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>The file 00-HP1-T501T<SPAN>.qvd is attached bellow.&nbsp;</SPAN></DIV> <DIV><SPAN>I do not understand why the code does not store the files.&nbsp;</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Thank you in advance!</SPAN></DIV> Wed, 28 Aug 2024 07:30:54 GMT draghici1109 2024-08-28T07:30:54Z https://community.qlik.com/t5/App-Development/Splitting-a-qvd-file/m-p/2478337#M100461 <P>Hello,</P> <P>I want to splitt the file xxx according to the values from this table:</P> <P>&nbsp;</P> <DIV>MANDT_AGS:</DIV> <DIV>load * inline [</DIV> <DIV>Mandant</DIV> <DIV>000</DIV> <DIV>002</DIV> <DIV>003</DIV> <DIV>090</DIV> <DIV>101</DIV> <DIV>103</DIV> <DIV>108</DIV> <DIV>114</DIV> <DIV>119</DIV> <DIV>133</DIV> <DIV>148</DIV> <DIV>153</DIV> <DIV>160</DIV> <DIV>167</DIV> <DIV>178</DIV> <DIV>197</DIV> <DIV>294</DIV> <DIV>300</DIV> <DIV>301</DIV> <DIV>304</DIV> <DIV>305</DIV> <DIV>308</DIV> <DIV>340</DIV> <DIV>350</DIV> <DIV>351</DIV> <DIV>366</DIV> <DIV>375</DIV> <DIV>515</DIV> <DIV>550</DIV> <DIV>555</DIV> <DIV>585</DIV> <DIV>600</DIV> <DIV>628</DIV> <DIV>644</DIV> <DIV>650</DIV> <DIV>710</DIV> <DIV>800</DIV> <DIV>850</DIV> <DIV>860</DIV> <DIV>866</DIV> <DIV>900</DIV> <DIV>998</DIV> <DIV>999</DIV> <DIV>];</DIV> <DIV>&nbsp;</DIV> <DIV><SPAN> For j = 0 to NoOfRows('MANDT_AGS') - 1</SPAN></DIV> <DIV><SPAN> set vMandt =;</SPAN></DIV> <DIV><SPAN> &nbsp; &nbsp; let vMandt = text(Peek('Mandant', $(j), 'MANDT_AGS'));</SPAN></DIV> <DIV><SPAN> trace vMandt $(vMandt); </SPAN></DIV> <DIV><SPAN> [$(vMandt)]:</SPAN></DIV> <DIV><SPAN> //wir splitten Daten nach Mandant</SPAN></DIV> <DIV><SPAN> NoConcatenate </SPAN></DIV> <DIV><SPAN> LOAD * </SPAN></DIV> <DIV><SPAN> from [..\DATA\00-HP1-T501T.qvd](qvd)</SPAN></DIV> <DIV><SPAN> WHERE text(MANDT) = $(vMandt);</SPAN></DIV> <DIV><SPAN> if NoOfRows('[$(vMandt)]') &gt; 0&nbsp; then </SPAN></DIV> <DIV><SPAN> STORE [$(vMandt)] into [..\DATA\SPLITTING\00-HP1-T501T-$(vMandt).qvd](qvd);</SPAN></DIV> <DIV><SPAN> drop Tables [$(vMandt)];</SPAN></DIV> <DIV><SPAN> ELSE</SPAN></DIV> <DIV><SPAN> drop tables [$(vMandt)];</SPAN></DIV> <DIV><SPAN> ENDIF;</SPAN></DIV> <DIV>&nbsp; NEXT j;</DIV> <DIV>EXIT SCRIPT;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>The file 00-HP1-T501T<SPAN>.qvd is attached bellow.&nbsp;</SPAN></DIV> <DIV><SPAN>I do not understand why the code does not store the files.&nbsp;</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>Thank you in advance!</SPAN></DIV> Wed, 28 Aug 2024 07:30:54 GMT https://community.qlik.com/t5/App-Development/Splitting-a-qvd-file/m-p/2478337#M100461 draghici1109 2024-08-28T07:30:54Z https://community.qlik.com/t5/App-Development/Splitting-a-qvd-file/m-p/2478353#M100462 <P>The square-brackets here are wrong:</P> <P><SPAN>if NoOfRows('<STRONG>[</STRONG>$(vMandt)<STRONG>]</STRONG>') &gt; 0&nbsp; then</SPAN></P> <P><SPAN>because all table/field-functions take the reference-parameter already as string and any space or special chars within the name must not be wrapped.</SPAN></P> <P>&nbsp;</P> Wed, 28 Aug 2024 07:49:33 GMT https://community.qlik.com/t5/App-Development/Splitting-a-qvd-file/m-p/2478353#M100462 marcus_sommer 2024-08-28T07:49:33Z