Is there any easy way to get aj to give me the last non null value of all the columns in the second table.
E.g aj[`time; tbl1; tbl2]
To clarify: the table to be joined ( tbl2 ) has several columns with nulls at different points in the different columns.
For each row in the first table ( tbl1 ), I want to get the last non null value of each column in the second table ( tbl2 ).
this is not the purpose of aj.you could use fills, as inaj[symtime;t;update fills c1,fills c2,… by sym from q]this would still return nulls on t’s rows where q.time>t.time by sym …On Mon, Dec 23, 2013 at 6:25 AM, naveen sharma<sharma.naveen888> wrote:> Is there any easy way to get aj to give me the last non null value of all> the columns in the second table.>> E.g aj[`time; tbl1; tbl2]>> To clarify: the table to be joined (tbl2) has several columns with nulls at> different points in the different columns.> For each row in the first table (tbl1), I want to get the last non null> value of each column in the second table (tbl2).>> –>
Submitted via Google Groups</sharma.naveen888>
>where q.time>t.time by sym
i meant, where there is no q.time<=t.time by sym
thanks!