Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How add excel sheets name with Different Schema in macro.

Shakil1
8 - Asteroid

Hello Guys,

 

I had created a macro to add all 40 sheets tab with different schema. But not sure how should I add the extra column with sheet name with containing all 40 sheet names in front of each row.

 

Request you to please help me into this asap.  Thanks!

3 REPLIES 3
ed_hayter
13 - Pulsar

If you have gone the batch macro route. Updating the sheetname with a control parameter. Then in the input tool in your macro go to option 4 and enable full path. From there within your batch macro before outputting you could parse the full path and pull the sheet name only.

 

image.png

aatalai
15 - Aurora

in the data input tool of your macro add output file name as a field

 

filename inoutput.PNG

Shakil1
8 - Asteroid

Thank you.. it's worked.

Labels
Top Solution Authors