Output Different in Macro vs Workflow

Hi - I've tried to put together a macro to make it easy for new Alteryx users to use dynamic input by using an excel mapping file. However, when I run the workflow in the Macro vs use the macro in a workflow I get different results - though the inputs haven't changed.

The macro return a dynamic input with File and Sheetname - as the standard tool would do - but the list of files is provided in an excel format.

I can't for the life of me work out what's causing this and any helpy would be appreciated.

DEdge

Macro run inside its own workflowMacro run in a separate workflow

EasyDynamicInput.yxzp

Easy Dynamic Input.zip

Output

Macros

Accepted answers

danilang

Hi @drdedge

You were so close. In the action tool connected to the "Please input the template file name and directory", you highlighted the "Output file name" attribute as opposed to the "File" attribute

Original

Corrected

With this change the results are identical

Dan

Example WF - EasyDynamicInput.yxzp

All comments

danilang

Hi @drdedge

Can you attach some the excel input files that you reference in your macro

.\Input\Example Input Files\2015.xlsx|||Sheet1$
.\Input\Example Input Files\2016.xlsx|||Sheet1$
.\Input\Example Input Files\DifferentSheetName.xlsx|||2018$
.\Input\Example Input Files\Other DIrectory\OtherDirectory.xlsx|||Sheet1$
.\Input\Example Input Files\TwoSheets.xlsx|||2019$
.\Input\Example Input Files\TwoSheets.xlsx|||2021$

Dan

drdedge

Whoops - updated with the zip file including it all.

dAve

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235