title: Iterate over HDFStore using chunksize saving into new HDFStore
body: <p>I got all my data into a HDFStore (yeah!), but how to get it out of it..</p>
  
  <p>I've saved 6 DataFrames as frame_table in my HDFStore. Each of these table looks like the following, but the length varies (date is Julian date).</p>
  
  <pre><code>&gt;&gt;&gt; a = store.select('var1')
  &gt;&gt;&gt; a.head()
                        var1
  x_coor y_coor date         
  928    310    2006257   133
  932    400    2006257   236
  939    311    2006257   253
  941    312    2006257   152
  942    283    2006257    68
  </code></pre>
  
  <p>Then I select from all my tables the values where the date is e.g > 2006256. </p>
  
  <pre><code>&gt;&gt;&gt; b = store.select_as_multiple(['var1','var2','var3','var4','var5','var6'], where=(pd.Term('date','&gt;',date)), selector= 'var1')
  &gt;&gt;&gt; b.head()
                        var1   var2  var3  var4  var5  var6
  x_coor y_coor date                                        
  928    310    2006257   133  14987  7045    18   240   171
                2006273   136      0  7327    30   253   161
                2006289   125      0  -239    83   217   168
                2006305    95  14604  6786    13   215    57
                2006321    84      0  4548    13   133    88
  </code></pre>
  
  <p>This works, but only for the relatively small .h5 files. So for my normal .h5 files I would like to temporarily store it in a HDFStore using chunksize (since I've to add a new column based on this selection to it as well). I thought like this (using <a href="https://github.com/pydata/pandas/issues/3032#issuecomment-14811709" rel="nofollow">this</a>):</p>
  
  <pre><code>for df in store.select_as_multiple(['var1','var2','var3','var4','var5','var6'], where=(pd.Term('date','&gt;',date)), selector= 'var1', chunksize=15):
      tempstore.put('test',pd.DataFrame(df))
  </code></pre>
  
  <p>But then only one chunk is added to the store. But with:</p>
  
  <pre><code>tempstore.append('test',pd.DataFrame(df))
  </code></pre>
  
  <p>I get ValueError: Can only append to Tables. What I'm doing wrong?</p>