title: Automating- Appending two text files to create 1 Excel file daily
body: <p>I have two files that come in daily to a shared drive. When they are posted, they come in with the current date as part of the file name. example ( dataset1_12517.txt and dataset2_12517.txt) the next day it posts it will be (dataset1_12617.txt and so on). They are pipe delimited files if that matters.</p>
  
  <p>I am trying to automate a daily merge of these two files to a single excel file that will be overwritten with each merge (file name remains the same) so my tableau dashboard can read the output without having to make a new connection daily. The tricky part is the file names will change daily, but they follow a specific naming convention.</p>
  
  <p>I have access to R Studio. I have not started writing code yet so looking for a place to start or a better solution. </p>