SOLVED
Fill down value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tiverson
8 - Asteroid
‎05-03-2022
02:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Desired Output
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
17 - Castor
‎05-03-2022
02:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @tiverson,
You can achieve this with a multi-row formula like so (workflow attached):
If you have any questions on how this works make sure to ask :)
HTH,
Ira
‎05-04-2022
06:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt, thanks for your help!
17 - Castor
‎05-04-2022
06:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries glad it worked !
