Is it possible to combine rows?

[kdelisi002]

I was wondering if this is possible to do in alteryx, I'm new to the software and everything I've tried isn't working. Thanks

[jdunkerley79]

Yes it is possible and various ways to do it.

One possible way would be:

First, filter to split the entity rows.

Then use a join tool set to join by record position

Sample attached doing this

[CharlieS · Accepted solution]

Nice work, @jdunkerley79!

I've attached another way to approach this. I used a Multi-Row formula to create a record ID, then a Summarize tool to return the desired output.

[Thableaus]

Hi @kdelisi002!
What you're looking for here is the Multi-Row Formula.

https://help.alteryx.com/2018.2/MultiRowFormula.htm

In This Case, you can do something Like that:

Use Multi-Row Formula

Create a New Field

IF Contains([Field1], "Entity") THEN [Field1] + " " + [Row+1:Field1]
ELSE Null()
ENDIF

Create New Field

Use Multi-Row Formula again

IF IsEmpty([Field2]) OR IsNull([Field2]) THEN [Row+1:Field2]
ELSE Null()
ENDIF

Then Use the Filter Tool 

[Field1] is not null

I appended a scratch for you.

I'm sure there are easier ways to do that, but that's the fastest way I could think.

Cheers,