Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
16 - Nebula

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