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

Question

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 · Answer

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

ShankerV · Answer

@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