Is it best to use Multi Row Formula or Formula for the following task

[XIIJAMIEIIX]

Hello, I'm pretty new to Alteryx and I'm trying to do formula that would do the following.

If Family Status is 'Parent' leave blank

If Family Status is 'Child' or 'Parent / Child' take Attached to GUID and compare GUID, if match then return Identifier from same row as GUID and write to the Parent Identifier.

 Would I need to use a Multi Row formula for this or is it best to use a formula?  

[ShankerV]

@XIIJAMIEIIX 

For your requirement, the best tool will be Formula tool.

Note: Formula tool is used when we need to refer the the same row for calculations

Multi-Row formula tool is used when we need to refer the the previous/below row for calculations

[ShankerV]

Hi @XIIJAMIEIIX 

Output Column = Parent Identifier

IF ( [Family Status] = 'Child' Or [Family Status] = 'Parent / Child' ) AND [Attached to GUID] = [GUID]

THEN [Identifier]

ELSE [Parent Identifier]

ENDIF

Many thanks

Shanker V