Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Please help me to fix this problem. below load script is showing error while loading the script.
tab1:
Load
id
Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)
resident existing table Group By id;
Hi Muruga,
as per my understanding we need to give like below in your script editor.
tab1:
Load
id,
Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5) As date_diff
resident tab1 Group By id;
If i understood your query please correct me by your Error screen shot
if it is not solved your issue , please copy & paste your script and screenshot of your error so that our folks will more help to you ASAP.
Not sure, but is the field called Rreviewdate or Reviewdate? may be just a typo?
tab1:
Load
id,
Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)
resident existing table Group By id;
Missed a comma after id ??
may be
tab1:
Load
id,
(Date#('2018-05-05','YYYY-MM-DD') -Floor(min(Rreviewdate)))/30.5
resident existing table Group By id;
Hi..
It is a date field (Rreviewdate is correct), have to take minimum date. If I remove the min function, Loading correctly.
Try this
tab1:
Load
id,
((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5)
resident existing table Group By id;
or please share your error
Hi.
it is my typo sorry !!!
I think, you should use group by with Aggregation function.
Hi Muruga,
as per my understanding we need to give like below in your script editor.
tab1:
Load
id,
Floor((Date('2018-05-05','YYYY-MM-DD') - (date(min(Rreviewdate),'YYYY-MM-DD')))/30.5) As date_diff
resident tab1 Group By id;
If i understood your query please correct me by your Error screen shot
if it is not solved your issue , please copy & paste your script and screenshot of your error so that our folks will more help to you ASAP.
Dear Experts,
Thank you for your valuable comments. As per your comments finally I resolved my end.
Now it is working fine.