Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried loading files using max date.
But error occurs while using where condition.
Table:
Load
ID,
trim(num(date(date#(subfield(Subfield(FileName(),'Incident ',2),'.',1),'DD-MMM-YY'),'DD/MM/YYYY'))) as File
From Excel
MaxDate:
Load
max(trim(num(File))) as MDate
Resident Table;
let Vmaxdate=Peek('MDate',0,'MaxDate');
NoConcatenate
Data:
Load *
Resident Log
where num(File)= num($(vMaxFileDate)) //Unexpected token error occurs while loading using where condition
;
the error is in the load?
the variable is Vmaxdate and in where you use vMaxFileDate ?
let Vmaxdate=Peek('MDate',0,'MaxDate');
NoConcatenate
Data:
Load *
Resident Log
where num(File)= num($(vMaxFileDate)) //Unexpected token error occurs while loading using where condition
;
Error is in the load. not in the UI.
where num(File)= num($(vMaxFileDate)) //Unexpected Token error
if i understood
where num(File)= num($(Vmaxdate) instead of where num(File)= num($(vMaxFileDate))
Ah!!! My mistake. It's working now. Many Thanks