Input Multiple files with different schemas (same layout) from one location

Hi,

I wish to create a tool which inputs files with different schemas (same layout however) based on a file location. I want this to be downloadable for people so they can also use it (so directory must be changeable) and also the number of files can vary. Is this possible to do?

Datasets

Developer Tools

Input

Macros

Accepted answers

JosephSerpis

Hi @jonnybruce have a look at this article which talks through solutions for your challenge. If you are working with excel files then the solution from this post is what you need. Addtionally this article talk through in detail how to get sheet name from excel files.

All comments

JosephSerpis

grazitti_sapna

@jonnybruce , here is a workflow which read files with different schema. It might be helpful to you. Please check this and it can be enhanced as per requirements. Let me know if you need any other help on this.

Multiple_Sheets.yxzp

jonnybruce

Will I be able to incorporate these macros into my workflow so its only one download?

jonnybruce

Thank you for this! Unfortunately I am unable to download this as I have to use the 2020 version of Alteryx; is there a version of this workflow which would be compatible with this?

omkarshinde

@JosephSerpis any way to add filename as extra column with every record while reading multiple files via this batch macro?

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167