Error-- Append tool

[BRRLL99]

hi

i have more than 2000 rows of data-set

company	SALES
A	10
B	20
c	30
D	40
E	50
F	60

OUTPUT:

company	SALES	TOTAL OF SALES
A	10	210
B	20	210
c	30	210
D	40	210
E	50	210
F	60	210

my target is total of sales 210 should be in each row

i have used Append Tool >> error im receiving is "there are more than 16 records in the source"

[binuacs · Accepted solution]

@BRRLL99 Select the allow all appends option from the append tool

[IraWatt · Accepted solution]

Hey @BRRLL99,

There is an option to stop this error:

[MarqueeCrew]

@BRRLL99 ,

 I was wondering why you are not using a formula tool with the value of 210 to get the [Total of Sales] field?

 Cheers,

 mark

[DataNath · Accepted solution]

@BRRLL99 what is your current approach i.e. what are you trying to append right now? This error kicks in by default as the append tool works by joining the source dataset to every single row of the target dataset and therefore in your case, you're multiplying your dataset of more than 2,000 rows (creating a dataset of at least 32,000 rows here, from 2k) by however many records are in your source and blowing up your dataset. The options to override this error are there in case this is intended and expected, but in most cases this is done by error and will lead to decreased performance. For your requirement, surely something like this is fine? Alteryx can handle this no problem as it's simply summing the sales and appending a single record to every row.