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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
It's likely for your particular data, the correct type of "delimiter" to use to merge everything into one column would be "\0" (backslash zero, without quotes) which tells the parser to use no delimiter and simply write everything to one column.
With \0, each line will be put in a separate row of data. Make sure your setting for field length is long enough to accommodate at minimum the largest line of text in your file to avoid truncation. If you also want everything in a single cell, you can use a Summarize tool to bring items back together before parsing and concatenating (you can use \n as a delimiter for a new line inside the row) as a v_string or v_wstring, though depending on how large your file is, this may not be possible due to max string lengths and generally I don't find it necessary for this type of processing as typically you would want each row in your file in a separate line.
Mike Spoula Solutions Architect - Services Alteryx