Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Generating row data based on a variable amount of info under it

5 - Atom

I have a csv file that is formatted like so:

List:Birds, 9
Penguin, 3
Cardinal, 4
Robbin, 2
List:Cats, 2
Tabby, 2
...

 

Everything under the item belong and sum to the list total, until the next list is stated. I'm struggling to convert the data to one row so that it would look like the following:

 

List:Birds, 9, Penguin, 3, Cardinal, 4, Robbin, 2

List:Cats, 2, Tabby, 2

...

 

Am I missing an easy solution to do this?

Alteryx Certified Partner

Hi @Cmcguire ,

 

You can flag the different groups with a multi-row formula and then use a summarize tool to concatenate all relevant strings together

 

AngelosPachis_0-1610484299357.png

 

Hope that helps,

 

Angelos

5 - Atom

This is exactly what I'm looking for! Thank you!

Labels