Import multiple tabs with different schemas using one Import Tool that do not combine

Question

Hi All,

I have spent the last three hours browsing this community and others to find what I thought would be an easy answer but so far has eluded me.  I am trying to import multiple, differing excel tabs from one .xlsx file into a workflow with a single input tool that go through different workflows themselves.  Each tab has different, unrelated data that I am trying to process and then recombine into a single, updated .xlsx with multiple tabs.  The main file updates quarterly and it would be very nice to be able to update only a single input tool rather than one per tab I'm trying to import.

I have read about batch macros, dynamic inputs, and so forth, but they all only seem to solve of combining multiple data sets into one.  How can I import multiple sets at once and keep them separate?

Best,

Z

BrandonB · Answer

It would look something like this

Zampy · Answer

Hi Brandon,

Thanks for the reply.  It still doesn't look like it'll provide the solution I was originally looking for.  However, if I can configure the individual input tools to update based on a more recent version in a directory I might be able to make it work.  Do you have an example of how a directory input would be able to pick based on date or version iteration?

Best,

Z

BrandonB · Answer

@Zampy you would benefit from a Directory tool which can look at a folder of files that you can use business logic to always pick the latest quarterly file. That way you won't have to reconfigure Input Data tools.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480