Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi you needt to put the expression in '
peek('CAS_TRANSIT_ID',-1,'TEMP_TABLE')
Hi you needt to put the expression in '
peek('CAS_TRANSIT_ID',-1,'TEMP_TABLE')
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);