Is it possible to read in an entire file into 1 field?

[adm510]

I'm trying to read in an entire file, so far I'm using a CSV reader with a delimiter of \0, but Alteryx keeps delimiting at every new line instead of at the EOF. How can I read in an entire file into 1 field, even if that file has multiple line breaks?

[MarqueeCrew · Accepted solution]

@adm510,

If you read it as a csv with \0 as a delimiter you can next add a constant to the data (say "Header" with value of "data") and then use a Cross-Tab Tool to put the rows back into a single field with a newline separator (\n).  Watch the FIELD SIZE configuration in both the Input and Transpose tools.

The final result is a single field with your input file present.

Cheers,

Mark

[adm510]

Thank you, I had tried using the summarize tool, but that kept adding all sorts of extra commas.