Multi Row If Statement - Help

[sslattery17]

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

[binu_acs]

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

[sslattery17]

@binu_acs 

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

[binu_acs]

@sslattery17 make sure the macro has the below property selected

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

[sslattery17]

@binu_acs 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.