The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Fill down value

tiverson
8 - Asteroid

I have data that has an account number assigned to the first row of data for each date.

I want to assign the account number to all of the rows.

Data

tiverson_0-1651612064968.png

 

Desired Output

tiverson_1-1651612094517.png

 

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @tiverson,

You can achieve this with a multi-row formula like so (workflow attached):

IraWatt_0-1651612349475.png

 

If you have any questions on how this works make sure to ask :) 

HTH,

Ira

tiverson
8 - Asteroid

@IraWatt, thanks for your help!

IraWatt
17 - Castor
17 - Castor

No worries glad it worked ! 

Labels
Top Solution Authors