Multi line CSV file to one field

[ewehrmann]

I am looking to convert all rows and columns of a CSV file to a single field.

How might I achieve this?

[fmvizcaino]

Hi @ewehrmann ,

For that, you can use \0 as the delimiter as image below.

See if that works for you and let me know.

Best,

Fernando Vizcaino

[JosephSerpis]

Hi @ewehrmann there are a couple of ways you could do this have mocked something up. Let me know what you think?

[danilang · Accepted solution]

Hi @ewehrmann 

If you want the exact output that you posted, change the separator in the summarize tool in @JosephSerpis' solution from a comma to "\n"(new line)

Dan

[ewehrmann]

That solution combines the columns into a single field but leave multiple rows

[ewehrmann]

Thank you. This workflow combined with Dan's tweak gave me a solution.

[gautams091]

Try with formula 

ToString(ToString([RecodID)+","+ToString([ITEM))