Output Template-Generating Empty Rows

Question

Hi community!

We have a problem with filling the attached template. In there, the rows colored yellow should be filled by the values from our dataset, orange are the subtotals of those and the purple are not applicable, so they will always be blank. We have the values but we could not find how to create the empty rows and then turn it into a table. This is our main question but if anyone has also suggestions of how we can output this template in Alteryx, that would be amazing. This template is almost static, other than the "Period" which would change for each quarter.

Thanks a lot already!
Best

Binnur

Template for Alteryx Community.xlsx

binnursev · Answer

Hi Dan,

Thank you for your response. Our data is very big but the values that we eventually need to use in this template are in the attached file. I hope this will be helpful.

Thanks a lot again

Best

Binnur

Test Data-.xlsx

danilang · Answer

Hi @binnursev

Can you attach a sample of what the input data looks like?  One that corresponds to the values in your output would be best.  Since the solution involves transforming the inputs to the outputs, we can't do much without the inputs.

Thanks

Dan