Reporting Alteryx output into an Excel template

Question

Dear All,

I am stuck at one place and would like to seek your help..

I have an Excel template where i need to output my Alteryx data,..Attached is a template- Sheet 2 contains the data from Alteryx and sheet 1 is the template.

Requirement is all the data from sheet 2 should flow to the cells in sheet 1 marked blue.

number of rows in sheet 2 for the categories English and Science may vary so the rows in sheet 1 should be created for each.

Output from Alteryx workflow-

Template-

Please help me with this,

Thanks in advance

echuong1 · Answer

There's not an "easy and quick" way to do this.

You'd essentially need to isolate each section of the template that you are going to output. This would be done with select, summarize, and filter tools. Then, you'd connect an output tool to each section. The output would need to go to a specified range and check the box to preserve formatting.

If you're able to upload a copy of your data and template, that would be helpful.