title: Get count of multiple files loaded in one statment
body: <p>I want to get a total amount of all rows in multiple files, which are saved as a QVD. Actually, with one file I would accomplish this like that:</p>
  
  <pre><code>data:
  LOAD count(id) AS counter FROM data.qvd (qvd);
  LET number = Peek('counter');
  </code></pre>
  
  <p>Of course, I know that I also can use <code>RowNo()</code> or <code>Count()</code> the whole table in one command, but I want to try this with that solution.</p>
  
  <p>Now when I try to fetch multiple files in one statement, as shown below, I always get only the count of the last loaded file and not the total:</p>
  
  <pre><code>data_multiple:
  LOAD count(id) AS counter FROM data_*.qvd (qvd);
  LET number_multiple = Peek('counter');
  </code></pre>
  
  <p>Now my question is how do I get the full amount of rows and not only the last one.</p>
  
  <p><strong>What I tried so far</strong></p>
  
  <p>I already tried to rearrange the statement like this:</p>
  
  <pre><code>data:
  LOAD id FROM data_*.qvd (qvd);
  
  LOAD Count(id) AS counter Resident data;
  LET number = Peek('counter');
  </code></pre>
  
  <p>But I do get still the same result. Is there some way how to achieve this?</p>