I am looking to combine a multi-row with multi-field. On a student dataset, some had one row per registration year and others had one record per student. I generated rows to replicate the one row per registration year. But now I have about 50 fields to backfill with the missing data.
Is there a way to combine the tools multi-row and multi-fields using the formula below?
IF not isnull([row-1: _Current-field_])
AND isnull([row 0: Current-field_])
THEN [row-1: _Current-field_])
ELSE [_Current-field_])
ENDIF
I was thinking of using a batch macro but got a bit stuck on how I would send the selected fields through to the macro to deal with one at a time.
