Fill down a record identifier

Question

I'm attempting to group person records by their NAMES, DOB and genders and issue a LINK_ID at various points in my project. If this person already has a LINK_ID, I want to copy it downward. If they have no previous LINK_ID, they will be given the value in the value in THIS_LINK_ID

series.png

FillSeries.yxmd

AbhilashR · Accepted Answer

Hi @gurth. attached workflow has my approach to help fill up the LINK_ID column. I took the approach of concatenating your grouping fields to create an artificial Custom Group, which in-turn is used within the Multirow formula tool to simplify the computation of Link_ID's.

IF [Tile_SequenceNum] = 1 
	THEN IIF(ISNULL([LINK_ID]),[THIS_LINK_ID],[LINK_ID])
ELSE [Row-1:LINK_ID]
ENDIF

I hope this helps, and let us know if this isn't what you were looking for.