Alteryx designer Discussions

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

Duplicate Rows Value

Highlighted
8 - Asteroid

Hi All,

 

I want to create duplicate rows for specific values, Below is the current dataset

Current Data.jpg

I want to achieve the below:

 

Untitled.jpg

Attached is the dataset.

 

Thanks in advance.

 

Regards,

 

Highlighted
17 - Castor
17 - Castor

Hi @Mostafa_Anwar 

 

You can do this with a Multi-row tool configured like this

 

if isnull([F1]) then
	[Row-1:F1]
else
	[F1]
endif

giving you 

r.png

 

Dan

 

Highlighted
8 - Asteroid

Many thanks Dan!

Labels