How to check calendar script for min and max date is working or not ?

[paulyeo11]

Hi All

I have a data model , which having sales table and GL Table , when i make using of script below to check the min and max calendar date , it seen to me that it does not work , and i am stack there , unable to move on , can some one help me ?

tmp:

LOAD

          min(date_GL) AS MinDate,

          max(date_GL) AS MaxDate

RESIDENT GL_TABLE;

CONCATENATE (tmp)

LOAD

          min(date) AS MinDate,

          max(date) AS MaxDate

RESIDENT sales_table;

Paul

[paulyeo11]

My issue is below script is not working , it does not bring the GL date into my calendar , as i have issue to compute stock balance.

tmp:

LOAD

          min(date_GL) AS MinDate,

          max(date_GL) AS MaxDate

RESIDENT GL_TABLE;

Hope some one can share with ne how to know above script is work ?

[er_mohit]

Try this

First to use aggregate function in scipt side it works with group by so there you mention one field on the basis of that you get min and max date from f=date_GL field

tmp:

LOAD Fieldname

          min(date(date_GL,'DD-MM-YYYY')) AS MinDate,

          max(date(date_GL,'DD-MM-YYYY) )AS MaxDate

RESIDENT GL_TABLE

group by Fieldname;

Here fieldname is that field on the basis of you get min and max date so, try t put your field here

[#4]

Hi,

Try this

JOIN(tmp)

LOAD

          min(date) AS MinDate,

          max(date) AS MaxDate

RESIDENT sales_table;

[paulyeo11]

hI Am & Er

mANY thank for your reply , i manage to solve my problem, it is due to i load the raw data twice.

Now i can move on.

Paul

[er_mohit · Accepted solution]

Acc. to your Question If your problem resolved then please mark it as either correct or helpful answer so that it might be helpful for other Deloper

Regards

Mohit