Populate an excel template

[aka_ash]

Hi,

I am looking to populate a formatted excel template with data from an output into specific cells.

This template would be need to populated with the relevant data and then output a separate file for each [ID]

I have attached a mock template and an expected output for one of the ID's

Below is some mock data used in the expected output.

Any assistance or tips would be greatly appreciated.

Date	ID	Data 1	Data 2	Value 1	Value 2	Value 3	Value 4	Value 5
1/03/2021	Red	East	BB	16.88	2	0.87	21	0.4
2/03/2021	Red	East	BB	184.9	8	0.775	21	0.4
3/03/2021	Orange	North	ZZ	15	9	0.546	21	0.4
4/03/2021	Green	South	YY	756.3	4	0.872	21	0.4

Thanks,

Ash

[Qiu]

@aka_ash 
I have to say this is a quite challenging one, resulting a workflow with a macro inside a macro.

The template has to be modified a bit, since somehow the blank row is illegal for Output tool.

[aka_ash]

Hi @Qiu,

Thank you for looking into this, Unfortunately it looks like the current version that we have of Alteryx does not support some functionality that you have in this workflow.

Would you be able to advise what you did to populate the template or send me some screenshots?

[Qiu]

@aka_ash 
Sorry to hear that we are having different version.

Here are the snapshots, but honestly since it is a macro in macro. therefore it will be difficult.

There is a post here introducing how to downgrade the workflow to your current version.

Follow it step by step and you should be able to open it.

Good luck.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-packaged-workflow-Fil...