Alteryx Designer Discussions

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

How to pull multiple excel worksheets from multiple excel files into Alteryx

Bluesky
5 - Atom

Hi

 

Can someone help me with a formula or process for setting up and creating a workflow to pull data from multiple excel worksheets from multiple excel files into Alteryx? I'd like to add a date stamp column and transpose some rows into columns as well.


Thank you

2 REPLIES 2
DawnDuong
11 - Bolide
11 - Bolide

Hi @Bluesky the community has many posts that address this question about importing multiple tabs from multiple files. I cannot find the post (really old one) that I used to refer to. The most comprehensive one I can find now is outside the community though

https://www.linkedin.com/pulse/how-import-multiple-excel-sheets-files-different-schema-bingqian-gao

Dawn.

Labels