Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to write sheet name and file name to batch macro related workflow

Chalsea
7 - Meteor

Good morning everyone,

 

I have a question and would like some help. I followed the link below and built two batch macro to write multiple sheet and multiple files with different schema. I followed the link below and built two batch macro to write multiple sheet and multiple files of excel sheet with different schema. However, in the workflow output which connect to the two batch macro, I couldn't get the file name and sheet name show up in the workflow output. Does anyone know how to do it at the workflow? Below is a screenshot of the workflow.  

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...

 

Much appreciated.5-26-2020 8-15-41 AM.png

 

Chalsea

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @Chalsea you might find the solution of this post helpful. 

Chalsea
7 - Meteor

@JosephSerpis Thank you so much!!! This solved it. Have a nice day! 🙂


Chalsea

Labels
Top Solution Authors