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.
Please note where there is just a comma, the value in that field will be NULL or empty.
To be fair the field values won't have a comma at the end but the reason why it is shown for consistency and ease of comparison to the original string.
If someone knows a better way to parse this other than RegEx please let me know.
Final question does anyone know how to request a particular format of data using the download tool. Currently i am using the download tool in Alteryx and it is viewing the data in one long field, but not in it's own rows and columns. Is it possible to instruct Alteryx somehow to request it already in rows and columns?