Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I hve master calender when i am usng innerjoin it shwng error......
y it is shwng error in temp calender?
example:
date --- 14-05-15
Change the MinMax table script like below,
MinMax:
Load
Max(Date#(Date,'DD-MM-YY')) as MaxDate,
Min(Date#(Date,'DD-MM-YY')) as MinDate
Resident TASKDETAILS;
Hi Suresh,
The variables vMaxDate & vMinDate values are empty. Verify below code carefully
MinMax:
Load
Max(Date) as MaxDate,
Min(Date) as MinDate
Resident TASKDETAILS;
// Creating Date Variables
Let vMinDate=Num(Peek('MinDate',0,'MinMax'));
Let vMaxDate=Num(Peek('MaxDate',0,'MinMax'));
Let vToday = $(vMaxDate);
Drop Table MinMax;
// TEMPORARY CALANDER
TempCal:
Load
Date($(vMinDate)+ RowNo() -1) as TempDate
AutoGenerate $(vMaxDate) - $(vMinDate) +1;
but values are there....what might be the reason?
yeah...its wrkng now... but... ihve five dates its shwng in diffrnt rows...
but i want in same row?
PFA'
in task code i hve 5......in dates its shwng in diff rows
error got resolved but ...date values shwng in diff rows
Hi,
All this fields are in Same table? Then do Group by in script, or use Max() for all the date fields.
Regards,
jagan.
yeah... all in same table..how can i do?
Hi,
Try like this
Data:
SELECT
Field1,
Field2,
Sum(Field3) AS Field3,
Sum(Field4) AS Field4
FROM TableName
Group By Field1, Field2;