Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Write Formatted Output in a specific Range or Cell Using Render

DataPirate26
10 - Fireball

Hi all, 

 

I am trying to write some values in a specific range and specific cells without the headers. I am able to write it using the Output tool but I want to write it using the render tool as I have to make some rows Bold. the Output configuration is given below which i want to replicate in render. 

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @DataPirate26,

You can remove the column headers in the table tool and other tools before they reach the render (as shown below). Does this answer your question?

IraWatt_0-1650532211704.png

 

DataPirate26
10 - Fireball

@IraWatt No actually I have to write data into a particular cell or specific range and the Entire Filepath needs to be replaced as well. I am writing data into a specific existing template. So only the above configuration won't give me the desired result. 

IraWatt
17 - Castor
17 - Castor

I've replicated the settings you specify and get this result: 

IraWatt_0-1650546795186.png

When I do this with render I get this:

IraWatt_1-1650546894487.png

 

Are you asking for empty rows here for the cell range? : 

IraWatt_2-1650546944814.png

The file path can be entered in the render tool here:

IraWatt_3-1650547195376.png

 

DataPirate26
10 - Fireball

@IraWatt So basically i have an existing template and i want to write some values in specific cells. So i will have to use the property overwrite sheet as I have to write output in different specific cells. That is what my ask is basically 

DataPirate26
10 - Fireball

@IraWatt Please see the attached Files below. One is the empty template and the other is with values desired output one. I want to write the values from cell A18. I have created batch bacro and output is coming fine using output tool but i want to use render tool as i have to change few Rows to BOLD. So can you help me out

Labels
Top Solution Authors