Hello,
Can anyone tell me why I am getting the below error in the append tool?
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.
You can ignore it by selecting "Allow All Appends".
@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,
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...