Appending data to existing sheet: Unique name for field error.
- 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
Hi all,
I am trying to append data to the end of an existing sheet in alteryx. I am receiving the below error and not sure why I am getting it/what it means. I literally am just selecting the data from input file, removing whitespace, and appending to a named range. The columns are exactly the same in both files, the input just has some additional data so I used the select to select certain columns. It worked twice at first but now I am getting the below error.
Output Data (759) Could not generate a unique name for field <1>, number 15855, after attempting 999 generated names
Workflow:
- Labels:
- Datasets
- Output
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @lomeoari
You can try a couple things
- Instead of appending the data in the output tool, you can add an input tool (pointing to the output field path) and a union tool. Combine the stream you have with the new input tool stream. This should accomplish the same thing that the output tool does
- In the 'Append Field Map' property change the custom mapping to a mapping not based on field names.
This could be a bug with Designer, as referenced here. If the two workarounds don't work, then try and attach the workflow with sample data.
