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.
If the changes that you want to make can be accomplished with a "Find" & "Replace" command, then they surely can be made with alteryx. I'd read the input file in with a .csv driver and set the delimiter to \0 (null). Now you can read and edit the file. When you save the file, go to a .txt file and make your file format .csv. You can use the same \0 delimiter and UNCHECK the First Row Contains Field Names.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Also when you read the file be sure to set the field length to something rediculous, I tend to go for 2000; otherwise if your workbook is mildly complex you may get truncation issues which then means your XML will be malformed should you not pick up on this issue and output your workvook.