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.
You can output to another sheet in the spreadsheet and have formulas in this sheet pick up the relevant fields
You can output the entire sheet in the correct format, by constructing the whole 'block' of text in Alteryx. To preserve formatting, the output can be done via the Render Tool rather than the output tool.
You can name the ranges in Excel and then output to those named ranges by referencing the range instead of the sheet. In this way you can set up a table with 2 columns, Data & Range. the issue that you have is that the field name is also going to be output. Maybe there is a way to get around that...
The recommended method would probably be option 1, however I have attached a module that shows 2&3.