Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Multi row comparison and date creation

Highlighted
7 - Meteor

I have to create new rows and flags corresponding to the rows. 

 

the new rows will have same flag which will be decided by their previous and next flag 

 

T and T is T

T and M is M

M and T is M

M and M is M

 

 

Input

 

IDDateCodeFlag
A4/9/2012abcT
A4/12/2012cdeT
A4/18/2012fghM

 

Output

 

IDDateCodeFlag
A4/9/2012abcT
A4/10/2012abcT
A4/11/2012abcT
A4/12/2012cdeT
A4/13/2012cdeM
A4/14/2012cdeM
A4/15/2012cdeM
A4/16/2012cdeM
A4/17/2012cdeM
A4/18/2012fghM
Highlighted
13 - Pulsar

Attaching sample workflow for your case.  Hope this is helpful. 

 

WorkflowWorkflowResultsResults

Labels