Looking to Create Batch Macro to Change File Extension

[kkkim]

Hello Alteryx Experts!

I am connecting to directory to pull dynamin number of files per day and change the extension type from .eml to .txt.

Looking to create a batch macro to output .eml files as .txt files --> and then input the txt files for the process.

Can you help set this one up correctly?

Thank you so much for your help!!!

[CharlieS]

I'm not familiar with the .eml file type. Google says it's related to emails. Are you able to open/read this file in Alteryx on its own? Can you attach an example .eml file here for us to test?

[SPetrie]

Are you just needing the raw file? You can import the .eml file directly and then do your changes on it and save it as .txt in the process.

Use a dynamic input tool and give it one of the .eml files as an example.

Select all files for them to show up

Then set it up like a csv that is not delineated.

Feed it the full path from a directory tool that has the .eml files you want.

A formula tool to change the extension and then an output tool to create your .txt versions.

You can do whatever other transformations on the file you need after that since they are already loaded into the workflow.

[omkarshinde]

@SPetrie  I am trying to do similar file conversion of xls to xlsx however i am getting 1 KB xlsx files generated which cant be opened in output please help

[jdminton]

Yes, no need to change the extension. @SPetrie has the way to bring the data in directly. If you are having trouble finding the file, you need to change the file type to "all files". 

@omkarshinde , you can't just change the extension on Excel files. You can use input data to bring into Alteryx and output data to send to .xlsx though.