Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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