Get multiple files from Sharepoint folder into Alteryx?

[Pbhave]

Hello,

I have a folder on Sharepoint with 40 excel sheets. I need all these files to input into Alteryx and append one below the other to create one single output file. 

All the 40 files have exact number of columns. 

Is there a way to do that? 

Thank you!

[ShankerV]

@Pbhave 

We have already the help page to import from share point.

https://help.alteryx.com/20221/designer/sharepoint-input-tool

Hope this helps!!!!

Shanker V

[Pbhave]

Thank you Shankar. II used Sharepoint input tool but it doesn't let me select more than one file at a time. 

Do you know if there is a way to do that? 

[ShankerV]

@Pbhave 

Use the Directory tool to read all the file names.

Then use the dynamic input tool to read all the datas in all the file one by one.

Many thanks

Shanker V

[ShankerV]

@Pbhave 

If your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

Many thanks

Shanker V

[wdavis]

Hi @Pbhave 

Are all the sheets the same format? E.g same number of columns?

Thanks

Will

[ShankerV]

@wdavis 

Along with same number of columns, the schema also should be same.

If the order of columns is different, then it will lead to pull all the information in one sheet which will mess up the joining of 40 sheets.

@Pbhave 

The schema of all sheets should be same.

Many thanks

Shanker V

[FrederikE]

Hey @Pbhave ,

What you need in order to solve your problem is a batch macro. 

You need a Sharepoint Tool to create all filepaths - Select "Import only list of file paths"

With this you can extract the file names, these you need as an input into a batch macro. 

The configuration of the macro has to be set up, so an action tool always changes the sheet names to the new ones. 

This way the macro will run 40 times and stack every single file underneath each other. 

This is a SharePoint solution that is independend of the Paths - if your workflow only needs to work localy, do the same thing with regular inputs.

[wdavis]

If they're the same, you can setup the SharePoint Input to read in from one folder. You  don't need to specify a file at this point, but the folder all 40 files sit in.

Then set the 'select sheet' to All Sheets

This should allow you to do it all from the SharePoint input

[Pbhave]

Thank you. Will try this out.