Load Script Getting error.

[palanimurugan]

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;

[sunny_talwar]

Not sure, but is the field called Rreviewdate or Reviewdate? may be just a typo?

[pradosh_thakur]

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 ??

[sasiparupudi1]

may be

tab1:

Load

id,

(Date#('2018-05-05','YYYY-MM-DD') -Floor(min(Rreviewdate)))/30.5

resident existing table Group By id;

[palanimurugan]

Hi..

It is a date field (Rreviewdate is correct), have to take minimum date. If I remove the min function, Loading correctly.

[prma7799]

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

[palanimurugan]

Hi.

it is my typo sorry !!!

[shiveshsingh]

I think, you should use group by with Aggregation function.

[ramasaisaksoft · Accepted solution]

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.

[palanimurugan]

Dear Experts,

Thank you for your valuable comments. As per your comments finally I resolved my end.

Now it is working fine.