Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Load of multiple Excel sheets using Wild Card

KaterinaSimerdova
7 - Meteor

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!

 

DIVISIONCOUNTRY2025-01-012025-02-012025-03-01
aaaindia281835
bbbfrance201030
     
4 REPLIES 4
DavidSkaife
14 - Magnetar

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
7 - Meteor

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
18 - Pollux
18 - Pollux

@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
7 - Meteor

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

Labels
Top Solution Authors