Reading Multiple Excel Files from SharePoint

[Domo]

Hello all,

I was wondering if you can help me to use Alteryx and Alteryx Gallery to read multiple excel files from my SharePoint location.

When using the SharePoint input tool, I'm able to connect and see the files using "Read Only List of Full Paths", but I'm not able to input all the data contained in these excel files.

Is there a workout to read these? And Can the workaround work on Alteryx Gallery?

Thanks

[jmgross72]

You could try to create a batch macro that pulls the SharePoint directory and unions each file to a yxdb for each record in that directory?

[abacon]

@Domo This will work exactly like a regular batch macro to pull data out of multiple files within a directory. i have listed the steps below:

1. Pull in SharePoint files using 'Read Only List of Full Paths'
2. Filter to [Name] endswith ".xlsx" (or desired file type)
3. Create a Batch Macro as seen in the screen shot
4. Configure the SharePoint tool to pull in the data from 1 file from your desired directory
5. Configure the Action tool to replace the string from the highlighted configurations.
6. Set Macro settings to Auto Configure by Name.
7. Pull Macro into main workflow and connect filter tool from step 2 into Macro and set field to be [Name]
8. Run

This should accomplish your goal, if so, please mark it as the solution so others may find it quicker.

Bacon

Main Workflow

Macro SetupSection to ReplaceString to replaceMacro Settings

[abacon]

@Domo If this worked for you, please mark it as the solution so others may find it faster.