Import multiple tabs with different schemas using one Import Tool that do not combine
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It would look something like this
