Data Load of multiple Excel sheets using Wild Card
- 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
Hello
I load multiple excel sheets from a folder using Wild Card. Those excel sheets have below format.
One excel contain data from 2024, second excel sheet contain data from 2025 etc. It means that the column names are not the same...
My issue is that only data from the first excel sheet are picked in the workflow.
Is there a way how to include data from all the excel sheets? Even if the column names are not the same? (I later on use the transpose tool to get the period).
I hope I was clear in explaining the issue and I hope someone could help?
Thank you!
DIVISION | COUNTRY | 2025-01-01 | 2025-02-01 | 2025-03-01 |
aaa | india | 28 | 18 | 35 |
bbb | france | 20 | 10 | 30 |
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As your column headers are not identical wildcard importing doesn't work. Have a look through this - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
You're going to need option 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, @DavidSkaife for your time!
It seems that the 3rd solution is for desktop only..? Or am I wrong? (I'm using Cloud version of Alteryx).
Thank you!
Katerina
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KaterinaSimerdova that's correct - there are not batch macros in Cloud as of yet. However this post is in Desktop not Cloud so we assume you are using Desktop
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My mistake - I chose wrong tag when creating this post. My apologies for that!
