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

Replicate for multiple row

SH_94
11 - Bolide

Dear community,

 

May i know how to write the formula in order to derive the result below to replicate the data? The objective is to check the column A if contain the "period", if yes, get the column B as Month Ouput. If no, then continue to use the previous data that contain "period".

 

SH_94_0-1662707820891.png

 

Many thanks for the help.

 

2 REPLIES 2
DataNath
17 - Castor

Hey @SH_94, for this request we can use the Multi-Row Formula with the following expression:

 

 

if [Decription] = 'Period' then [Detial] else [Row-1:Month] endif

DataNath_0-1662708402462.png

Sebastiaandb
12 - Quasar

Hi @SH_94 ,

 

I believe this is what you're looking for :D!

 

Sebastiaandb_0-1662708427300.png

 

Let me know if this is working for you.

 

Greetings,

 

Seb

Labels