make date year quater not working

[kunkumnaveen]

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

[t_chetirbok · Accepted solution]

Hello!

What if you'll make field like this: YEAR&QUATERS AS YEARQUATER

Date format doesn't include quarter