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
Usually this is where@Qiu and @mceleavey take over...
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.