Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?
Regards,
Przemek
INPUT
---------
Name, City
John, Berlin
Mary, London
, Paris
, Amsterdam
OUTPUT
-------------
Name, City
John, Berlin
Mary, London
Mary, Paris
Mary, Amsterdam
Yup.
If(Len(Trim(Name))=0,Peek(Name),Name) as Name
HIC
Thank you, Henric.