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

Batch Macro to combine all sheets and sheet names

BRRLL99
11 - Bolide

Hi 

I have created a batch macro which has combined all the sheets, 

in my end output I would like to have additional column from which sheet the rows are arrived.

ex: 

datacostSheet Name
A810Steel
D420Steel
datacostWood
B910Wood
B1020Wood
new datacostWood

 

Sample of my macro has been attached, since i have multiple sheets I would like to create this in a Batch Macro along with sheet names

3 REPLIES 3
FrederikE
13 - Pulsar

Hey @BRRLL99,

 

You can tick the option in the macros input tool to show the file name. Then the macros output will include this. 

FrederikE_0-1684743966723.png

 

FrederikE_0-1684744033807.png

 

 

BRRLL99
11 - Bolide

rows should take sheet name 

not file name

binu_acs
21 - Polaris

@BRRLL99 The batch macro I provided in the previous post has this field File Name, you can extract the sheet name from that field using the regex function

binuacs_0-1684744682953.png

 

Labels
Top Solution Authors