First non blank Record

[missteran]

Hi Alteryx Community - I'm trying to find a way how to get the first non-blank record for a records with the same key. I've put a before and after of what i'm looking for. Can someone please help? Thanks!

Before:

Line of Business	ID	Type	Commitment	Utilized
Melissa	123456	House	$     100,000
Melissa	123456			$      55,000
Melissa	958754	Condo	$     200,000
Melissa	958754			$      75,000
Melissa	156448	Building	$800,000.00
Melissa	156448			$500,000.00

After:

Line of Business	ID	Type	Commitment	Utilized
Melissa	123456	House	$     100,000
Melissa	123456	House		$      55,000
Melissa	958754	Condo	$     200,000
Melissa	958754	Condo		$      75,000
Melissa	156448	Building	$800,000.00
Melissa	156448	Building		$500,000.00

[alexnajm]

The Multi-Row formula tool should be used to cascade that value down! Something along the lines of:

IF [Type]=Null() THEN [Row-1: Type] ELSE [Type] ENDIF

[Qiu · Accepted solution]

@missteran 
Based on reply from @alexnajm , I usually put a record ID before processing and a Sort to make sure the Empty value for "Type" is on downward.

In the multi-row tool, we need to do Group as well.

[missteran]

Thank you Qiu and Alex the last solution worked!!!