Write Data to an Existing template

[DataPirate26]

I want to write the data to an Existing template. Can someone assist me to do the same. the Input File (Data.yxmd) and the output Template is shared below. 

[Jonathan-Sherman]

Hi @DataPirate26,

Which version of Alteryx are you on? The method you take will depend on the version as post 2021.1 (I think it was) there has been an option to preserve formatting on overwrite of sheet.

Kind regards,

Jonathan

[Jonathan-Sherman]

If you're running prior to 2021.1 I would suggest dumping your data in a new tab and adding in formulas to your table in the output template to pull the values through.

Kind regards,

Jonathan

[Sebastiaandb · Accepted solution]

@DataPirate26 @Jonathan-Sherman 

This post might help Solved: Outputting to a formatted excel template - Alteryx Community (found it via @danilang) 

Greetings,

Seb

[Jonathan-Sherman]

@Sebastiaandb I love the fact that everyone can have different solutions in Alteryx!

[Sebastiaandb]

@Jonathan-Sherman high five, me 2 haha! It really feels like playing with LEGO all day :-)!