Get last value from QVD

[cristian_av]

Hi

I'm trying to do a incremental reload. FOr that, I need to get the last value from a QVD file (It is ordered from min. first, to max as last record).

This is what I'm doing:

[TEMP_TABLE]:

LOAD CAS_TRANSIT_ID,NAME FROM ..\..\Datos\QVDs\Procesados\Consumos_EBI_Excel_v2.qvd (qvd);

LET vLastValue= PEEK(CAS_TRANSIT_ID,-1,TEMP_TABLE);

But when I see the vLastValue in the variable inspector, it has no value!

What I'm doing wrong?

Thank you!!

[Anonymous · Accepted solution]

Hi you needt to put the expression in '

peek('CAS_TRANSIT_ID',-1,'TEMP_TABLE')

[cristian_av]

Found it!

I had to use '' in peek. I have no idea why... in somefunctions I don't have to use the ''.

As this:

LET vLastValue= PEEK('CAS_TRANSIT_ID',-1,TEMP_TABLE);