ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

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

How to read multiple sheets from Excel file as separate columns in output file

ToxicBuoy
7 - Meteor

Hi,

I have a use case where I need to read separate sheets from Excel file to an output file but the data from each sheet as a separate column with sheet name as header name. Also the number of sheets gets added each week.

Attached sample for reference.

Qiu
17 - Castor

@ToxicBuoy 

This should work for your use case.

0210-ToxicBuoy.PNG

ToxicBuoy
7 - Meteor

Thanks @Qiu . However I am unable to open the package since I am using a lower ver.. Could you xplain what you did on cross tab tool?

Qiu
17 - Castor

@ToxicBuoy 

Here

sad.PNG

ToxicBuoy
7 - Meteor

Thanks @Qiu , thats perfectly works

Qiu
17 - Castor

@ToxicBuoy 
Glad to help and would appreciate you could makr this repy as accept😁

Labels