topic Re: Output to an Excel Template in Alteryx Designer Desktop Discussions

Output to an Excel Template

Raj008 — Thu, 27 May 2021 12:36:32 GMT

Hi All,

I am trying to output to an excel template from an input from another excel. The input excel has 11 fields (columns) and the output excel template has 20 fields (columns). I need to update the 11 fields' value to the output template excel. The field names in output and input are the same.

Thanks in advance...

Raj008

Re: Output to an Excel Template

mceleavey — Thu, 27 May 2021 12:49:57 GMT

Hi @Raj008 ,

Can you provide the data and the template?

mock data is fine.

Re: Output to an Excel Template

Raj008 — Thu, 27 May 2021 16:54:14 GMT

Hi mcelevaey,

Please find the attached.

Thanks,

Raj008

Re: Output to an Excel Template

mceleavey — Thu, 27 May 2021 18:14:43 GMT

@Raj008 ,

not much to go on here, but if you want to take the template and fit the data to the template I've built that.

Other than that, you would just use a select tool to rename the columns, put them in order and output.

I've attached the first method.