LOAD only if value is greater than already existing values

[#1]

Hi all,

I first load a table like this:

     dataa:

         LOAD id, date from ./my_data.qvd (qvd);

Then, I load a second table like this:

     noconcatenate

     datab:

     sql select id, date from my_table;

Now I want to concatenate the data in table datab to the data in table dataa, but only the lines in datab that have a date value higher than any existing date value in table dataa.

Any tip about how to do this?

Thank you

[Nicole-Smith]

dataa:

LOAD id, date from ./my_data.qvd (qvd);

maxdatetemp:

LOAD max(date) as maxdate RESIDENT dataa;

LET vMaxDate = PEEK('maxdate',0,'maxdatetemp');

DROP TABLE maxdatetemp;

concatenate (dataa)

sql select id, date from my_table where date > '$(vMaxDate)';