Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

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

ToxicBuoy
6 - Meteoroid

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
16 - Nebula

@ToxicBuoy 

This should work for your use case.

0210-ToxicBuoy.PNG

ToxicBuoy
6 - Meteoroid

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
16 - Nebula

@ToxicBuoy 

Here

sad.PNG

ToxicBuoy
6 - Meteoroid

Thanks @Qiu , thats perfectly works

Qiu
16 - Nebula

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

Labels