lastNot

lastNot(X, [k])

X is a vector, a matrix or a table.

k (optional) is a scalar.

If X is a vector:

• If k is not specified: return the last element of X that is not NULL.

• If k is specified: return the last element of X that is neither k nor NULL.

If X is a matrix/table, conduct the aforementioned calculation within each column of X. The result is a vector.

lastNot also supports querying DFS tables and partitioned tables.

lastNot(1 6 0 0 0, 0);
// output
6

lastNot(1 6 0 0 0 2 3 0 NULL, 0);
// output
3

lastNot(1 6 0 0 0 2 3 0 NULL);
// output
0

t=table(1 1 1 1 1 2 2 2 2 2 as id, 1 2 0 0 0 3 NULL NULL 0 0 as x);
t;

select lastNot(x, 0) from t group by id;

m=matrix(2 NULL 1 0 NULL, NULL 2 NULL 6 0);
m;

lastNot(m, 0);
// output
[1,6]