Hello,i am not getting any error while reload at the same time i am not getting the required output data.........
i am getting year field,quaters fields from DATE_OF_REVIEW and later i am trying to join them both by using two functiond
1.makedate= MakeDate(YEAR,QUATERS) AS YEARQUATER
2.date#= date(Date#(YEAR&''&QUATERS),'YYYYQ') AS YEARQUATER
looks like either function is not working ....can u say why .....
o/p i am looking is: YEARQUATERS
2015Q1
2015Q2
2015Q3
2015Q4.......
SO ON
SuppilerScore:
LOAD CLIENT,
LIFNR,
VENDOR_NAME,
ROLE,
DATE_OF_REVIEW,
QM_SCORE,
QM_MAX,
CS_SCORE,
CS_MAX,
GENERAL_SCORE,
GENERAL_MAX,
PROC_SCORE,
PROC_MAX,
MANU_SCORE,
MANU_MAX,
TOTAL_SCORE,
MAX_SCORE,
'Q'&Ceil(MONTH(DATE_OF_REVIEW)/3) AS QUATERS,
//year(DATE_OF_REVIEW) as YEAR,
Year(Date(DATE_OF_REVIEW, 'YYYY-MM-DD'))AS YEAR
FROM
(qvd);
TABLE2:
LOAD
VENDOR_NAME as name1,
ROLE,
DATE_OF_REVIEW,
QM_SCORE,
CS_SCORE,
GENERAL_SCORE,
PROC_SCORE,
MANU_SCORE,
TOTAL_SCORE,
QUATERS,
YEAR,
date(Date#(YEAR&''&QUATERS),'YYYYQ') AS YEARQUATER
//MakeDate(YEAR,QUATERS) AS YEARQUATER
Resident SuppilerScore;
DROP Table SuppilerScore;
thanks
naveen
