Populate Excel Template

[apmaggard]

Hello,

I am trying to create an Alteryx workflow that uses the Data file to fill out the Template file. It's important that I am able to keep the format in the Template file including the subtotals / totals. This template is only a portion of a much larger table, so hoping there isn't a lot of manual work to keep all the subtotals / totals in my full file. Typically I would use a SUMIFS in excel to populate the Template file, but having a hard time figuring out how to do this in Alteryx while keeping the format / subtotals / totals. 

Thanks,

A

[stataltgee]

@apmaggard I've tried creating the output file based on your data. Hopefully this helps!