Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Mapping Output to Excel

grsZndYmPnUfC
5 - Atom

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

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

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
6 - Meteoroid

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?

Labels
Top Solution Authors