This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Learn MoreI have a folder of .txt files that I want to convert, in bulk, to a folder of excel files. I am having trouble getting my multiple file macro and .txt files to work. How would I perform the conversion to all files in the folder?
@easher003 You can use the directory tool with the dynamic input tool to bring in the text files. This only works if they have the same schema, if the schema change I can share how to do that as well.
The key is to bring in the files as a .csv with no delimiter (\0) and then use the text to columns tools to parse it out if needed. Does this help?