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

Find End Date and set for all related records

HenpetsGordres1
8 - Asteroid

Related to previously asked question

 

I now need to add an 'EndDate' column which takes the last day I was in a country and sets that as the End Date for all rows with the same ID. The column is shown below:

 

StephenRodgers_0-1578997624141.png

 

I have tried the following Multi-Row formula which is returning incorrect results:

IF [ID] = [Row-1:ID]
THEN [Date]
ELSE [Row+1:Date]
ENDIF

 

Many thanks

3 REPLIES 3
OllieClarke
15 - Aurora
15 - Aurora

Hi @HenpetsGordres1 here's a workflow showing what you want to do:

I've put in two options depending on how your date is formatted

OllieClarke_0-1578998271733.png

Hope that helps,

 

Ollie

afv2688
16 - Nebula
16 - Nebula

Hello @HenpetsGordres1 ,

 

You cannot use the multi row formula since this tool only affects the curent row, the leading one and the trailing one.

 

For this use better the application @OllieClarke  developed.

 

Regards

HenpetsGordres1
8 - Asteroid

Many thanks, works brilliantly!

Labels