Alternate fuction to Lastvalue() in the script, as it is consuming huge memory while reloading ??

dhasharadh — Sat, 16 Nov 2024 20:29:22 GMT

Hi All,

we are using lastvalue() fuction in the script almost 30 times due to which the script execution taking huge memory and leads to Inconstance memory Type A error.

Ex:

Table_A:

load A,B,c ... from xyz.qvd;

Tabla B:

load lastvalue(A) as lastname_a,

lastvalue(B) as lastname_b,

resident Table_A ;

like above lastvalue() fuction used almost 30 times in the script. I think replacing it with some similar fuction which will serve the purpose is going to fix this issue..

please suggest the suitable function to replace the lastvalue() fuction. Thanks Much in advance.

Re: Alternate fuction to Lastvalue() in the script, as it is consuming huge memory while reloading ?

jonathandienst — Wed, 10 Jul 2019 05:55:01 GMT

Perhaps you can use Peek() to get the results from the previous load:

Table_A: load A,B,c ... from xyz.qvd; Let vA = Peek('A', -1); //-1 gets last value loaded Let vB = Peek('B', -1);

If you need them in a table, then add:

Table_B: LOAD '$(vA)' as lastname_a, '$(vB)' as lastname_b AUTOGENERATE 1;

topic Re: Alternate fuction to Lastvalue() in the script, as it is consuming huge memory while reloading ? in QlikView

Alternate fuction to Lastvalue() in the script, as it is consuming huge memory while reloading ??

Re: Alternate fuction to Lastvalue() in the script, as it is consuming huge memory while reloading ?