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
@sslattery17 updated the macro to exclude the records before and after
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
@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?
@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.