Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');
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');
Sunny, as always thank you very much, Simon