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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

sounds like a standard process.  What have you tried and where are you stuck?

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

So I am getting the standard error message about 'hand authored ' queries therefore it will not upload to the cloud

 

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

    you should use \\emirprd\edwdata as your only data source.

     

    can you show some more of the Power Query script?

     

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

      Sure--I must connect to 48 folders to pull the latest .csv file

      ex:  Step 1 = add Folder

      Step 2 = set up custom filter so it pulls after October (3 months prior from today)

       

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

        - connect to the main share only, not to the subfolders

        - have a list of all the subfolders

        - iterate through them and fetch a list of all the files in these folders that match your criteria

        - fetch the files as needed.