We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi Row If Statement - Help

sslattery17
8 - Asteroid

I used the below if statement to fill down the "Primary Name Field and I will use the same for the 3 date fields and other columns; however, before I can do that; I need to fill in the empty date field with a generic holder like 0000-00-00 or no data.  I am not sure how to accomplish this without it also filling in all empty rows unless I can configure mutli-step if statement for example but cant get it to work properly.  In order to use name field; would need date field as step one then I can fill down name.  I know order makes a difference. Any assistance would be helpful.

 

Fill empty date field:

if !isempty([Primary Name]) and if isempty([Lease End Date])

then 0000-00-00

else [Lease End Date]

 

Fill down empty rows:

if isempty([Primary Name])
then [Row-1:Primary Name]
else [Primary Name]
endif

 

 

Primary Name         Move-In Date        Lease Begin Date     Lease End Date    Charge Code

Alindo DosReis        2019-04-27           2024-05-01               2025-04-30            Rent

Alindo DosReis                                                                                                     Amenity Rent

Alindo DosReis                                                                                                     Garage Fee

David Nordquist       2020-02-01           2025-01-01                                             Amenity Rent 

David Nordquist                                                                                                    Month to Month

David Nordquist                                                                                                    Concession-Part-time Employee

Gregory Daniel        2020-03-01            2025-04-01               2026-03-31           Amenity Rent

13 REPLIES 13
binuacs
21 - Polaris

@sslattery17 updated the macro to exclude the records before and after

image.png

sslattery17
8 - Asteroid

@binuacs 

 

Thank you for the updated macro.  When I installed the macro something changed with my workflow and not all properties are showing.  Barton Mills and Belmont are missing?  

 

Maybe I uploaded wrong or maybe a down stream filter is causing it.  I will take a look first thing in am and let you know what I find.

 

Shannon S

binuacs
21 - Polaris

@sslattery17 make sure the macro has the below property selected

image.png

 

also are you seeing any error in the result window while running the macro with your input files?

sslattery17
8 - Asteroid

@binuacs My apologies for not getting back to this sooner.  We had few internal changes, and I took on additional workload. 

 

Please see attached Belmont result audit with new macro update.  I am missing property id data and have missing columns now (rent and parking/carport/garage).  I attached the workflow package.

 

I will continue to research cause but hoping you can still assist. 

Labels
Top Solution Authors