Generate rows by summing the values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I need to SUM the values that contains the same [Nro ID] and generate a new row with the result.
Input:
Expected output:
I leave an example workflow,
Thank you.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is how you can do it.
workflow:
1. Using record id to set order.
2. Using formula tool to remove commas and spaces in numeric field. Using select tool to convert to double.
3. Using Multi-row formula to create groupid.
4. Using summarize to get sum and set max groupid +1 for the sum row.
5. Using union tool join them back.
6. Using sort tool to sort them by order.
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To get sum of Total Comprobante for each Nro ID you can use Summarize tool : sum of Total grouped by Nro ID.
Then Union it with input file.
I notied that you also have text in other columns (but I am not sure if there is any logic behind it?), so for example you can in Summarize Tool add First by other columns so you will have first text from other columns for each group of Nro ID.
Both solutions attached.
btw I corrected manually input file (Total column), but the workflow should work on your original data.
Let me know if you have any comments/questions,
Karolina
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BautistaC888 I believe the attached is what you have...
you should be able to cut out my multi-field formula tool assuming that your numeric column is recognized as numbers. Mine does a manual transformation of "xxx.xxx,xx" to "xxx,xxx.xx" and converts to number.