Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

transform each file the same way before merge

Hello, let's suppose I have many files in the folder (daily added). All these csv have the same structure.  So I need to apply the same power query transformation to each file before I can marge th...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    If you use SharePoint folder connector or Folder connector to connect to multiple files, when you combine files, you will select a sample file like below. After combining, the structure of queries will be changed like below. You just have to edit the Transform Sample File query. Then all changes will be applied to the combined data in Query1. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

If you use SharePoint folder connector or Folder connector to connect to multiple files, when you combine files, you will select a sample file like below. After combining, the structure of queries will be changed like below. You just have to edit the Transform Sample File query. Then all changes will be applied to the combined data in Query1. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.