Error-- Append tool

Question

hi

i have more than 2000 rows of data-set

companySALESA10B20c30D40E50F60

OUTPUT:

companySALESTOTAL OF SALESA10210B20210c30210D40210E50210F60210

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"

binu_acs · Accepted Answer

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

IraWatt · Accepted Answer

Hey @BRRLL99,

There is an option to stop this error:

DataNath · Accepted Answer

@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.