I have a set of sample data that I'm trying to add up by the ID column. I can use SUMIFS in Excel but my real data has many rows and I'd like to automate this step through Alteryx. I cannot use another SUM tool because I want to keep the Due Date and the sources columns. Is there a formula that can help achieve the result that SUMIFs will do and also want to keep just the first occurrence of the SUM in the result column. Please see my attached data file and the desired output, and I really appreciate your help!!! Thank you so much!!!
