Add sheet name when importing multiple sheets using macro

Carlyn

I am working on a macro to import multiple sheets from an excel file.

I tried Dynamic input initially, but as the tabs have different schema this wouldn't work.

So next option is a Macro.

It appears to have worked, however, I am looking to add a column with the sheet name on the output.

Can someone help me with how I can do this please?

Multi tab flow.yxmd

Input

Help

Accepted answers

All comments

OTrieger

@Carlyn
You need to select to open in the input data tool, 5 Output File Name as Field, select file name

ChrisTX

Inside the macro, in the Macro Input tool, under Template Input > File Input > Configure, use the drop-down for 5 Output File Name as Field.

Screenshot 2024-09-11 063940.png

Chris

Carlyn

Hi Chris

Thanks for responding. I am not particularly comfortable with macros yet in Alteryx so this may seem like a daft question, but when I change to using the macro input tool and then try to link it within my workflow by replacing the general input tool, there is no way to connect it that I can see.

Macro Input tool.PNG

When I try to update option 5 in the general input tool I get the following error.

Input tool.PNG

Macro input.PNG

Do you know what I am missing/doing wrong?

OTrieger

@Carlyn

The path is wrong and that is the error that you get.

OTrieger

check the formula tool as there path is been set there. You need to get a full path, .......file,xlsx|||Sheet1 or something like that, depends on the sheet name