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

Reference a specific Cell

garretwalters12
8 - Asteroid

What formula can I use in order to populate the date cell for ID SC-208 to match the date for RI-401?

 

DateID
09/18/2018RI-401

09/20/2018

RI-402
 SC-208
3 REPLIES 3
kat
12 - Quasar

Hi @garretwalters12

 

For this use case specifically you could use the multi row formula to update the Date field:

 

if [ID] = 'SC-208'
    then [Row-1:Date]
    else [Date]
endif

 Hope this helps.

danilang
19 - Altair
19 - Altair

Hi @garretwalters12

 

What's your criteria for matching the date?  Do you want the first one in the list? The 1st one of the previous group(RI-xxx)?  Always the date for RI-401

 

@kat it's  [row-2:Date].  typo no doubt:)

 

Dan

kat
12 - Quasar

good catch @danilang!

Labels