Function in alteryx - summarize varios rows into one

[Cesc]

Hello Alteryx forum,

I was trying to create a summary of accounts per document number. So what I needed to do is the following:

1. I have this dataset. I would like to add another row that summarizes the field 3DIG per Nº asiento periodo 2. So, the first three lines of the new field would be:

N asiento    NEW FIELD

15                430+438

20                432+574

21                432+555+665

22                430+432                

Would really appreciate your help.

Thanks

[atcodedog05]

Hi @Cesc 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Hi @Cesc 

Can you provide the expected output I might be a bit confused about what the expected output. If you want only to summarize you can do it like this.

Hope this helps : )

[Cesc]

Hi, thanks for you quick reply.

I don't want to actually sum them (like you show above), i want to concatenate the 3DIG like this:

[Cesc]

Here is how i achieved it in excel

[atcodedog05 · Accepted solution]

Hi @Cesc 

Here is how you can do it.

Workflow:

Hope this helps : )

[MarqueeCrew]

@Cesc ,

One tool is all that you need for this challenge:  Text to Columns

By using a + for the Delimiter and choosing to Split to rows, you get your data as requested.

Cheers,

Mark

[atcodedog05 · Accepted solution]

Hi @Cesc 

Thank you for the file here is the updated workflow

Hope this helps : )

[binuacs]

@Cesc 

[atcodedog05]

Happy to help : ) @Cesc 

Cheers and have a nice day!