Let Variable returns blank in script

[43918084]

I am testing a script that use Let below.  Icannot get DD-4066 in table test2.  May I know if I am doing anything wrong?

test:
Load * Inline
[
issuekey
DD-4066,

];

let vkey= peek(test.issuekey);

test2:
load * Inline [
abc
'$(vkey)'
];

[Mark_Leifeld · Accepted solution]

Hi @43918084 ,

you used the peek function wrong. 

https://help.qlik.com/de-DE/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunc...

This script should work: 

test:
Load * Inline
[
issuekey
DD-4066

];

let vkey= peek('issuekey',0,'test');

Trace >>>>>>> $(vkey);
test2:
load * Inline [
abc
'$(vkey)'
];

[43918084]

Thanks a lot for your immediate expertise.  Really appreciate it 🙂

[Mark_Leifeld]

I'm always happy to help 😉