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
Solved! Go to 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.
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,