Mapping Output to Excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?