Forum Discussion

Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

Over 45+ folder structures to pull .txt/.csv file from via Power Query

INTRO: My mission is to pull the most recent file from various folders that are sent from the PAYOR and organize them by the most recent date per payor. Then I must pull the values for TOTALS PAID b...
Need Help
Tips and Tricks
Tutorial Requests
Karolina411's avatar
Karolina411
Icon for Helper V rankHelper V
2 years ago

Thank you for your reply! The issue is how to just import .txt files > than a certain date.  The dates are found in the name itself and the column  pulled in Power Query.  How can just have a refresh on file names > than , say , November 23rd, 2023?  Thank you!

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

create a new date column from the file name, then apply your filter on that new column.

  • Karolina411's avatar
    Karolina411
    Icon for Helper V rankHelper V
    2 years ago

    I must test that as I found if I do any filtering on the date column then when a new file enters the folders it does not update my slicer to show the latest file as it is obeying the filter placed.