Free Trial

Alteryx Designer Desktop Discussions

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

Stop batch macro from adding filename to output

sh_mryan
5 - Atom

Hi All,

 

I've got a directory with 1,000's of text files that I need to convert into csv files. While converting the text files I also have to add missing column headings and reorder the columns. All text files have the same schema.

 

2023-06-28_9-11-36.jpg

 

 

The attached batch macro does everything I am looking for, except it adds the FileName as a column. How do stop the batch macro from adding the FileName to each output ?

 

2023-06-28_9-12-59.jpg

 

 

2 REPLIES 2
TimN
13 - Pulsar

I tried this way - changed macro to macro output and then added the file output to the main WF.  Seems to work.

 

 

 

 

 
 
 

 

binuacs
21 - Polaris

@sh_mryan made a few changes in the macro and it seems to be working for me

 

Screenshot 2023-06-28 041813.png

Labels
Top Solution Authors