Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am stuck in a situation where I am getting trouble with my variable.
I have create the variable like let Vlast_modified_date = peek('Last_updated_date','0','Report_date_table')
now I am using it in where to filter the data like this
Sample11:
load *
from .... Sales.xslx where date > $(Vlast_modified_date) . this is not working
can you please help me on this
Try using single quotes:
Load * From .... Sales.xslx where date > '$(Vlast_modified_date)' ;
If your Last_updated_date is interpreted and correctly formatted, this should work.
Hi, try to check and be sure that both 'date' and 'Vlast_modified_date' are the same format. You can try to add date() function for this. Maybe this can help to align variable and dimension.