append field tool issue
- 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
Hello,
Can anyone tell me why I am getting the below error in the append tool?
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @minakshi ,
I think this is related to the amount of data in the second data source. If I am not mistaken it takes into consideration amount of columns.
You can disable it. Please look at the bottom of the screen below for reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can ignore it by selecting "Allow All Appends".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Emil_Kos solution's will work for you.
However, be very careful when doing this. The append tool performs a Cartesian Join on the two input datasets, so if both datasets have 100 rows, the output will have 10,000 rows. The data can quickly become very large, and so it is recommended to leave the error setting on to prevent this from happening.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
for what it's worth, the dropdown setting in the append tool configuration that the others have mentioned is the way to resolve this, but in the resolution/monitor/configurations etc i've had, that setting always requires you to scroll down to it in the configuration, which is not obvious because there's a whole bunch of white space in the configuration so you're likely to think there's nothing below it. you just have to know it's there or be very observant...
