Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch macro - file name not coming back into workflow

michaelcjoyce
7 - Meteor

In my batch macro, I am outputting the file name as a field.  The file name field does in fact appear in the results window within the batch macro, but it is not coming through in the actual workflow when I connect the macro to a Select tool.  I would appreciate guidance here.  Thank you.

7 REPLIES 7
TUSHAR050392
11 - Bolide

@michaelcjoyce Can you share a picture of your batch macro? Just making sure - are using a macro output in your batch macro ?

michaelcjoyce
7 - Meteor

@TUSHAR050392 yes, using a macro output:

 

 

 

Batch macro 1.PNG

KGT
13 - Pulsar

One thing to look at is the interface designer in the macro and which union option is set. If it's "common set of fields" then maybe filename is not working on one file and so the field is being dropped. Make sure this is on "Union by fieldname" or something similar to that.

TUSHAR050392
11 - Bolide

@michaelcjoyce I tried to replicate your macro, all the updates and fields are coming out correctly for me. I would like to highlight the things that I am doing-

1. In the input tool, option 5 value is - File Name only

2. In my interface designer setting, I have the output mode selected to first option - All iterations will have same output (schema)

 

Please try this and let me know if it is helpful

michaelcjoyce
7 - Meteor

Thank you @TUSHAR050392 .  How do I change the output mode on the interface design:

 

 

 
 
 
 
 
 
 

 

michaelcjoyce
7 - Meteor

Interface.PNG

TUSHAR050392
11 - Bolide

@michaelcjoyce You can do that in the interface designer - layout view, the wheel icon which is 4th one in the left window where you have the wand.

Labels
Top Solution Authors