Is there a timestamp that identifies that last row? if there is, you could use that. Since the Peek function isn't working, maybe you could use a GroupBy function to group the Tagnames and then get the max record. I'd have to see some sample data to get more specific. Is there a specific reason why the Peek function isn't working?
Hi nate, thanks for the reply. I have used Max function, but, I am unable to the date value into a variable, but I am able to get the Date value in text object
please look at the code below
vTagForPO=(FillA, FillB,FillC);
NoConcatenate
GetPOTime:
SELECT TagName as TagsForPOTime,
DateTime as POTime
FROM
History
WHERE
TagName IN$(vTagForPO)
AND DateTime >= '$(vProdStartTime)'
AND DateTime <= '$(vThisExecTime)'
NoConcatenate
FactGetPOChangeTime:
LOAD
TagsForPOTime,
if(TagsForPOTime='Fill A',POTime,0) as Fill A Time,
if(TagsForPOTime='Fill B',POTime,0) as Fill B Time,
if(TagsForPOTime='Fill C',POTime,0) as Fill C Time
Resident GetPOChangeTime;
LET vFillATime=Max([Fill A Time]);
LET vFillBTime=Max([Fill B Time]);
LET vFillCPOTime=Timestamp(Max(Fill C TIme),'YYYY-MM-DD hh:mm:ss');
when i use the this Timestamp(Max(Fill C TIme),'YYYY-MM-DD hh:mm:ss'); expression in a text object, I am getting the exact value
