Multi row formula

[praneshsapmm]

Hi,

I have this requirement , looking for help to solve : 

Recordcount	Rectype	DocDate	Docnum
1	A02	null	1234
2	A02	null	1234
3	A02	null	1234
4	A02	null	1234
5	A02	null	1234
6	A02	null	1234
7	A02	null	1234
8	A02	null	1234
9	A02	null	1234
10	A05	27-06-2022	1234

How to fill in the null doc dates of Record type A02 with doc date available with Record type 'A05' using multi row . 

Thanks 

[FrederikE]

Hey @praneshsapmm,

Do a Desending sort on your recordcount.

Afterwards you can use a Multirow Tool to replace Nulls with the row above. 

Then you can sort to the original order again,

[praneshsapmm]

Hi @FrederikE ,

I did this .

[Row+1:DOCDATE]=[DOCDATE] .But does not work .

Thanks

[FrederikE]

Hey @praneshsapmm,

No need for the equal sign, that is already buildin every Alteryx formula by default, as a specific column has ot be selected. 

See: