Hi @Inactive User,
Attached is a workflow that would do this.
Searching for the yxmd file from the "Open File" dialog box does require you to change the "File of type" to "All Files" (not "All Data Files"). When you select, a "Resolve file Type" window will pop up. configure it as shown above.
Back in the input tool, you'll update the path by adding a wildcard so that it'll read in multiple files within the specified directory that end with '.yxmd'. if you only want to do one file, then skip this. Note that when you change the file path, you'll probably get asked to resolved the file type again... do it the same way.
- Reading as CSV allows gives you additional options to tell Alteryx how to read the file in
- This option will create a new field with the name of the file. This will be used to create the new file path that'll end with .xml instead of .yxmd
- This is the specifier for no delimiter, which was added by selecting "None" from the resolve window
- Your data doesnt have headers so be sure this is unchecked, which should have also been done automatically if you unchecked "First row contains field names" from the resolve window
- Default is 254, which will not be long enough in some cases. You don't need to use the size i specified, but make sure that you dont get any truncation conversion error messages
The formula tool in there is what you'll use to create the new file path. unless you have a user profile on your machine names "jgo", be sure to change that to an existing directory on your machine.
Hope this helps!
Best,
Jimmy
