Load Excel files from list of File Paths

[CDunhill]

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

[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.

[mmishal001 · Accepted solution]

@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

[CDunhill]

This is useful, thank you.

As is often the way, the problem is that I was asking the wrong question - I was trying to import a specific range within a sheet. However, I can see your solution will work and I can handle the range extraction 'down-stream'.