Mapping Output to Excel

[grsZndYmPnUfC]

I followed the instructions for using an Excel template in my output.  My Alteryx flow now take the data from the flow and places them into my template.  The problem is that the flow simply puts them in the exact order from the input.

I need to map each column from the input to a very specific column in the output template.

For example my input looks like:

Vendor, City, State

And my output template looks like:

Unrelated1, Vendor, Phone, Zip , City, State

But right now Alteryx just drops the data into the first three columns of my output template

[DavidP]

You will have to create all the fields in the template in your workflow with a formula tool and put them in the right order with a select tool so that the fields in your workflow exactly match the fields in the template.

[David8]

You are wrong, there is a way to map to an existing excel file... hence the "append field map." it just doesn't work. any advice?