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.
In the Summarize tool, concatenate the column and change the Separator to \n, which means newline:
Run the workflow.
View the Output anchor of the Summarize tool in the Results window pane.
Right-click on the record and select Copy All Records with Headers:
Right-click on the canvas directly and paste.
A new Text Input will appear with the multi-line record inside a single cell.
And that’s it! Why use this over the Summarize tool in your workflow? Well, you don’t really need to. This trick does help follow the best practice of reducing the number of tools in a workflow and improving performance (Summarize does a lot of work, even though performance gain here is minimal). It also looks cool to have a multi-line record inside a Text Input tool. 😉
Our use case involved creating static HTML pages and replacing certain values as needed. You probably won’t do this but it’s cool to know a new Text Input tool can be quickly created by pasting copied results directly on the canvas.