Hello everyone,
I’m looking for advice on how to create an aggregate data table to join with another data set. For instance given Table Salespeople (containing sales employees) and Table SalesActivity (containing who made the sale, amount, quantity, etc.), I want to find the total sales for each salesperson. This is nearly identical to the Excel examples for sumifs
The “brute force” solution I’ve found is:
- Create a copy of the SalesActivity table,
- Remove all but the “Employees” column,
- Remove duplicates on that,
- Add an “Amount” column back in,
- Finally iterate through each row in the original table, adding the amount from each row to the related Employee.
I was mildly surprised that I was able to get this to “work” after only a few tries, however this approach will take almost 15 minutes for a table containing 4k rows. Not only does this make debugging a nightmare, but it’s highly unideal to showcase UiPath’s capabilities.
Browsing the .net Framework, it seems like an alternative is to write up quite a bit of code, and use the DataColumn Expression to create a defined value (using the parent/child functionality, near bottom of page), however this seems to require creating a dataset, then adding the parent/child relationship, then finally setting the expression.
Is there a less complicated way to do this? If not, is there documentation or training on how to do this? Most of the .net examples are heavily centered in .net, which is not the easiest to replicate in UiPath (vs a fully featured C# IDE)