Import only the latest file

Follow

rakshit bhargava

• June 05, 2019 05:44

How to import only the latest file created/modified using the directory list node and excel node. An example workflow will be helpful.

0

• 

  Adrian Williams

  • June 07, 2019 10:21

  The data flow would look like this:

  

  First configure the Directory list to read the required directory and configure the Pattern property to select the appropriate files. e.g. filter the results to only output .xlsx files:

  

  The output data from the Directory List node includes the modified datetime:

  

  Configure a Sort node to order the matching files by descending Modified datetime:

  

  The first record will then be the most recently modified .xlsx file in the folder. Then use the Head node to only output the record for this file:

  

  You can then pass this record into the Excel File node which is configured to obtain the filename from the 'FileName' input field:

  

   

   

   

   

  1

  Comment actions Permalink
• 

  rakshit bhargava

  • June 10, 2019 04:15

  Thank you for the example. It worked successfully

  0

  Comment actions Permalink
• 

  Joshua Campbell

  • June 26, 2020 17:37
  • Edited

  Thanks Rakshit for sharing and Adrian for your guidance. This was helpful in a data flow I'm working on. 

  - Josh

  0

  Comment actions Permalink

Please sign in to leave a comment.