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.
Just be a little wary of re-saving CSV from Excel. For example, I've lost time values from date-time fields doing this, for example (or it's been rounded to the hour or something). Great that it's solved, but just beware that a re-save can introduce issues if the default formatting input is set and drops data on the re-save due to pushing it back into CSV-capable formats from an excel format view. So just keep an eye on it is all I'm saying I suppose 🙂
There appears to be an extra column in the data without a header, but if you know what it is you can rename that one in the select tool. The rest can be dynamically renamed using the Dynamic Rename Tool. I've taken your sample data and packaged it up with a workflow that shows you how it's done. See attached.
One of the benefits of using Alteryx and doing this pipe delimited work around is that you're saving time and steps if this is a file you're reading in regularly you might not want to go the save as CSV route in addition to the potential data issues you might introduce after opening it in Excel and the work of opening it and going through each field to say it's text to prevent those issues is a bit time consuming. At least for me it was with 70 columns in my file.
With 5 tools you can do it and you only have to edit a couple of items for any new file or if there's a change to the existing file. Just look at the count of pipes and update the Text to Columns tool with that number and you're done if it's a relatively clean file. If there are missing headers in the data or extra delimiters you have a couple more steps but you can see them and clearly make the changes to adjust the workflow. If there are no changes you set this up once and you're good to run.