Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi folks,
i have hr,finance views .
hr view data from 1-1-2012 to 1-29-2012
finance data from 2-1-2002 to 1-1-2012
how can i create common calender for the 2 views or different calender for 2 views ?
plz help me its urgent
Hi,
Let me know what are field in HR and Finance.
You can simply concatenate the two views and arrive Month, Year, Week etc from that table.
Temp:
LOAD
*
FROM HR;
CONCATENATE
LOAD
*
FROM Finance;
Data:
LOAD
*,
Year(DateField) AS Year,
Month(DateField) AS Month,
'
'
'
'
RESIDENT Temp;
DROP TABLE Temp;
Hope this helps you.
Regards,
Jagan.
hi ,
hr i have joining data from 1-1-2001 to 12-25-2011
finance i have invoice monthyear from 2-2002 to 11-2012
in finance other date field january month sales
how can i integrate these date fields to create calender.
Hi,
Can you attach sample file.
Regards,
Jagan.
Hi,
Change the date field name of both hr and finance views to the date field name in master calendar.
Celambarasan
Hi,
Cau u give us sample data.
Iyyappan.
hi plz find the attachment
Thanks in Advance