Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Appending from a folder - new file added error

Hi Everyone,   I am running into a refresh data issue in Power Query.   Background: Appending from a folder. This document shows my steps.   Documentation   These are the first three files I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

When you add Hailey's file to the folder, and then sort alphabetically, Hailey's is now the first file. So now you have to replace Haily Tutor Log instead of Judy Tutor Log.

 

--Nate

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

     super helpful. I Can follow your logic. But I have a question on the execution. 

    where do I replace Judy for hailey?

     

     Luis

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous -

     

    I was able to refresh the folder in Power Query.

     

     

    It is all good until I get to the Changed Type1. 

     

     

    I must delete each step after Change Type1 to make the append from the folder work.

     

    I thought append from folder would make it more automatic.

     

    I must be missing something.

     

    Luis