Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have you tried only loading the run_date from DB? Check if it is actually being fetched from the DB. And try another load with changed sequence like:
Master:
load
day(run_date) as day,
monthname(run_date) as month_tt,
year(run_date) as year_tt
;
select run_date from tt_sdp_rpx_summary;
when I give only the select statement , it feteches data from db.
but, when I give the load statement , it gives the error => field not found for run_date.
I tried your load statement. It gives the same error.
is there any other way to select date ranges?
See, now it looks like this discussion has been initiated by me (which is certainly not). This is possibly because Anju Gopinath has deleted the first post. It would be nice if community people please have a note of this issue.
Coming back to question, I would request to share a sample app with described expected result.
I did not delete any post. I just used branch feature under the discussion.This is the first time I have used it and apparently, this is how it appears...
how do I insert a qvw?
Click on 'Reply'->Top right corner of the editor 'Use advanced editor' -> Bottom right corner 'Attach'