topic Update existing file- Add (Sum) the data when new data come in daily in Alteryx Designer Desktop Discussions

Update existing file- Add (Sum) the data when new data come in daily

bleu — Thu, 17 Feb 2022 13:40:47 GMT

I'm sure there's a simple solution but I can't figure it out.

- Only one file exists

- When new data comes from in the database read the file and add the data to the correct columns

- Output the new data (with the totals) to the same spreadsheet (overwrite it daily)

I don't know how to add the data to existing data. I don't want to append it. I want it added.

Any advice would help!

Thank you

Re: Update existing file- Add (Sum) the data when new data come in daily

binu_acs — Thu, 17 Feb 2022 14:11:26 GMT

@bleu

Re: Update existing file- Add (Sum) the data when new data come in daily

bleu — Thu, 17 Feb 2022 14:19:35 GMT

OK. I've got 50+ columns so I'll just have to make sure all the field names match up every single time or my results will be off when I use the Record ID.

Thank you Quasar! This will work.