Create a Variable from a Field value in script

[#1]

Hi, hope someone will be able to help me with this, I need to set a field value to a variable in my script so that I can use it in a where clause when loading other tables. I tried this:

Qualify *;
  LASTTIMESTAMP:
LOAD End_Number
  FROM
[\\euuklefp01\apps_usr\Data Team\LastTimeStamps.csv]  (txt, utf8, embedded labels, delimiter is ',', msq);
UNQUALIFY *;

LET vUpdateDateStart = LASTTIMESTAMP.End_Number

but I get an error message from the last line, is there a way to do it? The contents of End_Number change every hour.

The file I am loading from only contains one number and a header and it looks like this

Any help would be appreciated, Thank you Simon

[sunny_talwar · Accepted solution]

May be like this:

Qualify *;
LASTTIMESTAMP:
LOAD End_Number
FROM
[\\euuklefp01\apps_usr\Data Team\LastTimeStamps.csv]  (txt, utf8, embedded labels, delimiter is ',', msq);
UNQUALIFY *;

LET vUpdateDateStart = Peek('LASTTIMESTAMP.End_Number');

[#3]

Sunny, as always thank you very much, Simon