topic Re: Fill empty values with previous rows in App Development

Fill empty values with previous rows

rulohx87 — Sat, 16 Nov 2024 06:16:38 GMT

Hello everyone !

I try to fill a name with a previous name where the values are nulls. I Tried with the function Previous():

IF(isNull(Name),Previous(Name),Name) // It's ok, but return one value.

Table:

And I need these values.

Thanks,

trdandamudi — Fri, 22 Mar 2019 08:22:57 GMT

One way of doing this is as below:

Data:
Load
id,
If(Len(Name)>0,Name,Peek(Name)) as Name;
Load * Inline [
id, Name
1, Danna
2, Issac
3,
4,
5, John
6,
];

Hope this helps.

koilpni — Thu, 25 Aug 2022 14:48:48 GMT

Previous cannot work for a row that has not been already loaded or present in internal.