bulk upload Excel sheets to Alteryx Designer
- 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
I have sales data for each store saved in individual sheet in the same Excel file. The sheets use the same naming pattern, for example, Sales, Store A, Sales, Store B.....Sales, Store X. When there's new store sales data, it will follow the same naming pattern.
Below is my current solution. However, it cannot dynamically add new store data.
Is there any bulk upload solution that I can input all sales data at once, and dynamically add data from sheets of new stores in the future?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Rather than selecting a specific sheet in your data inputs, you can select the option to pull in the list of sheet names. You can then attach a Dynamic Input tool which is able to stack the data from all of those sheets in one tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @LEXQ2005 ,
a more flexible solution would be to use an Input tool to get a list of all sheets in the Excel file (instead of selecting a sheet name, select the option "Import only the list of sheet names". Connect this Input tool to a Dynamic Input tool. You have to select one of the sheets in your Excel file as a template and use the list of sheet names from the Input tool as List of data sources. This should work for existing, but also for new sheets. Hope this is helpful.
Regards
Roland
