Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
5 years ago
Solved

Problem to combine multiple files with different sheet names.

Hi All,   I have a problem with combine multiple files from Sharepoint folder.   Al the files are in one folder and have all the same name and colomn name/format. But each file, the tab also has...
Need Help
  • AilleryO's avatar
    AilleryO
    5 years ago

    Hi,

     

    Did you load your file, using connection Folder or Excel ?

    If you create a connection to a folder, you should have a function (fx), parameters, and a query in the left panel.

     

    The solution you pointed out is in M code (Power Query) and need to be copy and paste on the formula bar (new steps) or in the advanced editor.

     

    But I can offer you a more simple solution, if...

    you always need the first sheet  (1st sheet = 0, 2nd=1...) of your Excel files, you can also use :

    #"Sales_Sheet" = Source{0}[Data]

    instead of

    #"Sales_Sheet" = Source{[Item="Sales Week 32",Kind="Sheet"]}[Data]

     

    Hope this helps you, let us know

Frixel's avatar
Frixel
Post Prodigy
5 years ago

AilleryO 

 

I use the sharepoint folder connector  like this.

 

And the code you give, wher do i paste that in?

Is that also in the formule bar?

like here?

AilleryO's avatar
AilleryO
Memorable Member
3 years ago

Hi,

The modification of code I gave you is usefull for a Folder Connection but it is not the same as you're using a SharePoint Folder Connection.

References are not the same and it is not working the same way.

I'm not sure if you can do it the same way with a SharePoint folder.

Maybe other members can help you with this ?

Let us know or do not hesitate to open a new discusssion as the issue is not the same.