Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Added missing dates to rows

tiverson
8 - Asteroid
‎02-15-2022 01:32 PM

I want to add dates to records that are missing them.

After the dates are added, I want to calculate a value based on another record.

I'm guessing I want to use the Multi Row Formula, but not sure.

 

Data 

tiverson_0-1644960628748.png

 

Output

tiverson_1-1644960646353.png

 

 

Preview file
14 KB
Labels:
Reply
0 Likes
1 REPLY 1
Thableaus
17 - Castor
17 - Castor
‎02-15-2022 01:50 PM

Hi @tiverson 

 

See solution attached. Change the input file to your own input and see if it works.


Cheers,

Solution Add Rows.yxmd
Reply
go to user group event calendar
Labels