title: Read selected rows from multiple files in a folder in R
body: <p>I have around 170 parquet files in a folder and am trying to select rows that match a value in a column. but i get this error after a few runs. this code works if I manually put a few files but not for all. can someone please help?</p>
  <pre><code>Error: Problem with `filter()` input `..1`.
  i Input `..1` is `pq$service_id %in% serviceroutes`.
  x Input `..1` must be of size 1, not size 0.
  Run `rlang::last_error()` to see where the error occurred.
  In addition: Warning message:
  Unknown or uninitialised column: `service_id`.
  </code></pre>
  <p>Code:</p>
  <pre><code>MTWs&lt;-list.files(path=filepath)
  serviceroutes&lt;-unique(servicesumGWY$service_id)
  outData1 &lt;-data.table()
  for (file in MTWs) {
   fp&lt;-paste0(filepath,file)
   pq&lt;- read_parquet(fp)
   dataT &lt;- pq %&gt;% filter(pq$service_id %in% serviceroutes)
   outData1&lt;- rbind(outData1,dataT,fill=TRUE)
  }
  </code></pre>