cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hymieho Regular Visitor
Regular Visitor

Load/combine multiple files, but only the two most recent files in the folder

Following up to my question here: I now need to compare the two most recent files to look for changes/differences. How do I keep/combine the two latest files (9/26 & 10/23 in this case). I see List.MaxN but I can't figure out how to leverage it here.... Help?

 

2017-08-01.CSV

2017-09-26.CSV

2017-10-23.CSV

etc.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
drewlewis15 Member
Member

Re: Load/combine multiple files, but only the two most recent files in the folder

One option could be to sort your date created column in descending order, and then only keep the first two rows. 

2 REPLIES 2
drewlewis15 Member
Member

Re: Load/combine multiple files, but only the two most recent files in the folder

One option could be to sort your date created column in descending order, and then only keep the first two rows. 

Highlighted
hymieho Regular Visitor
Regular Visitor

Re: Load/combine multiple files, but only the two most recent files in the folder

So simple... of course! Thanks.