Generate rows by summing the values

[BautistaC888]

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.

[atcodedog05]

Hi @BautistaC888 

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 🙂

[KarolinaRoza]

hi @BautistaC888 

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

[apathetichell]

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.