There is a important difference between peek() and previous().
Previous() will consider the previous read row of your source table. In your case T1.
Peek() will consider the previous written row in your destination table. In your case T2.
When populating row with id 106 the previous() function will look at the empty name cell in T1. Peek will look att the last written cell value for 105 in T2 containing the value C.
You don't need to handle this in two steps you could write something like this:
T1:
LOAD
id,
IF(len(name)>0,name,peek('name')) as name
INLINE [
id, name
101, A
102,
103, B
104, C
105,
106,
107,
108, T
109, N
];
Cheers
Vegar Lie Arntsen
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
