Looking to Create Batch Macro to Change File Extension

Question

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!!!

jdminton · Answer

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.

omkarshinde · Answer

@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

SPetrie · Answer

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.

email test.yxmd