Replace data in an Output file

[Jenina]

Hello,

Is there a way to replace the data in Output file instead of overwriting/creating new ones? I want to retain the table format in my output.

Input file is from a different excel workbook.

Thank you!

[NMangera]

@Jenina ,

If the requirement is to replace the values in an output file whilst retaining existing formatting, then you can use the configurations options of the table tool (reporting palette) to create a template that will persist each time the workflow is run with new data. 

[Jenina]

@NMangera 

Hello - The process owner requires the output to be like the attached. I can't configure the table like that so I resorted to replace. 

Thanks!

Jenina

[NMangera · Accepted solution]

you can preserve formatting on overwrite if you put in a range when you output. If you have the same layout everyday, I'd suggest putting the columns that you don't want overwritten at the end of your table. 

In the attached workflow, I only brought in the fields that I wanted to update by naming the cell range . I then apply a simple data cleaning operation by replacing the blanks zeros and then I output directly back into the same sheet.  Again,  I selected the range that I wanted to output to and checked the box that said 'Preserve Formatting on Overwrite' in the Options.

Hope that helps!

[Jenina]

Thanks!