So I am used to using Excel and Sum Ifs. Is there anyway to do that in Alteryx. Basically I have multiple part numbers in the Part column that are same I am trying to combine and sum the PO quanity. For example line 3 and 4 are the same part I only want one column with the PO quanitty being the sum of both which would be 513pcs?
@codyfink You can use the Summarize tool and group by the string field and sum the Int field
Yeah, use the Summarize tool to Group by those dimensions and Sum the measures you want provided the data types are correct. Dimensions should ideally be V_WStrings and measures should be numeric in nature.
Best,
Cal
If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!
Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/