Data population from a table/dataset into multiple excel template for each transaction

[bperiasw]

Hi Everyone,

I have a requirement to pull a data set from a table (which is more straight forward in Alteryx) and populate data in an existing Excel template into specific cells with the respective sheet. Also generate multiple sheets within the excel file for each record from the data set.

Have anyone done Alteryx workflows for similar kind of requirement and any pointer would be much appreciated. 

Input data:

Output blank template in which data to be populated: 

Sample Outputs:

Data1 - Sheet1

Data2 - Sheet2

[DavidP]

Hi @bperiasw 

The way I would do it is to essentially get your data into a format where you can write to one cell at a time. Since you know what the location is of each cell that you need to write to, you can specify this with the Output Data tool. So you want your data to look something like this:

Note how I created a one by one cell range for each value and created a file path with filename, sheetname and the cell range for each value.

No you can simply remove all other columns, keeping only the Value field and the fullpath and use the output data tool to write all the values to their respective locations.

A few things to note:

Check Option 5 "Skip field names"

Check "Take File/Table Name from Field"

Select "Change entire file path"

Select Fullpath as the field to use

Uncheck "Keep Field in Output"

I attache the example workflow