This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The first section is the two rows that I am starting with. I would like to sum the bolded columns (quantity, lbs, level) but keep the rest of the information that same so it reads as the second section. What tool would you suggest to achieve this output?
Essentially you have to groupby all the fields that are common between the two rows (Name,F8, FileName, New Field) that are non-numeric (apart from RecordID) and then sum all the numeric fields(quantity, gal, level).
Thank you @clmc9601 for the screenshot! I tried to use the summarize tool but for some reason, it will not let me select sum for the quantity, gal, and lb field. Do I need to change them from a V_wstring maybe?