Find and Replace OR Multi Row Formula?

Question

Hello
I am hoping to get some guidance.
I have a data set with a single column that combines Year/Month (data type: V_String). See Figure 1 below.

I need to split out the Year/Month into 2 columns - Year and Month.
This is simple enough with the text to columns tool.
Where it gets tricky is trying to populate the rows after the first row.
I have tried using the multi-row tool, but I get stuck

Figure 1.

Row NumberMonthRegionDATA12022/JanACT - Metro02 ACT - Rural03 New South Wales - Metro04 New South Wales - Rural05 Northern Territory - Metro06 Northern Territory - Rural07 Queensland - Metro08 Queensland - Rural09 South Australia - Metro010 South Australia - Rural011 Tasmania - Metro012 Tasmania - Rural013 Victoria - Metro014 Victoria - Rural015 Western Australia - Metro0

Step 1.

Its trying to configure the multi-row tool with the correct condition function that is where I am struggling

I think the problem is coming in with my Expression:
IF IsNull([Year/Month])
then [Row-1:Month]
else [Month]
endif

Please let me know if anyone has a solve for this?

SPetrie · Answer

Your formula is telling it to use [Row-1:Month], but that would also be null, you want it to be [Row-1:Month Name]

I would also suggest an alternative of using the multirow tool to bring down the Year/Month column instead and then splitting to columns so you are not having to do multi-rows on both columns (assuming you need both columns).

IF IsNull([Year/Month]) then [Row-1:Year/Month] else [Year/Month] endif

apathetichell · Answer

you want to bring over the field from [Row-1:Month Name] (your new field - not [Month] you also may need to set up scenarios for what happens for the first and last record.