Data Load of multiple Excel sheets using Wild Card

[KaterinaSimerdova]

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

[davidskaife · Accepted solution]

Hi @KaterinaSimerdova 

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

[KaterinaSimerdova]

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

[alexnajm]

@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

[KaterinaSimerdova]

My mistake - I chose wrong tag when creating this post. My apologies for that!