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.
Is there a way to create a field that adds columns with with a target string in the field name? For the example below, add columns with "Sales_" in the header? Currently, I use a formula tool with the expression, [Sales_Jan]+[Sales_Feb]+[Sales_Mar], but this gets cumbersome as more months' sales gets added into the data. Thanks.
The attached workflow should do the trick. I use the Cross Tab tool to create Name - Value pairs and then filter the rows that just contain Sales in the Name. The values are then summed and the total columns are rejoined to the original input on the record ID that was added using the record ID tool.