Load Excel files from list of File Paths

Hi,

Is it possible to load specific (but the same) sheets from a bunch of Excel files (all same format as each other) as listed in a Text Input?

Ideally the files would be opened then processed before Union'ing into one.

Is this do-able? Couldn't see quite this question anywhere on the Community pages but apologies if I've missed it. I'd be happy with a link to solve this!

Thanks, regards

Chris

Workflow

Input

Accepted answers

mmishal001

@CDunhill

Yes it is possible to load specific and same sheets of the same format to Alteryx and union them all together as long as the schema (structure and type is the same). As you have mentioned they are all in the same format and this shouldn't be an issue. But if is is follow steps from this link.

Bring in a Director tool and make sure configuration is as per below (include sub directories if you folder has multiple folders within)

Your dynamic input schema should look like this,

Like I've mentioned - this will work if all your excel files have one sheet and are of the same schema.

I hope this helps!

Best regards,

Mishal

All comments

Kenda

Hey @CDunhill

Check out the Dynamic Input tool! This should get you exactly what you're looking for.

CDunhill

Thanks - I'm looking into it now. I've not used this before - looks like I may need to check out some examples.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335