Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fill down a record identifier

gurth
7 - Meteor

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

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora

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

 

AbhilashR_0-1593402224524.png

 

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

gurth
7 - Meteor

Yes. Works perfectly. Thanks a lot!

Labels