2 Replies Latest reply: Jun 5, 2016 12:45 PM by shweta gupta RSS

    Concatenation of tables and Auto Calendar Script

    shweta gupta

      Hi All,

       

      I have concatenated three different tables with same headers. i.e I have concatenated data of April 2014, May 2014 and June 2014.

      After loading script i.e

       

      Apr 2014;

      concatenate

       

      may2014

      Concatenate

       

      June 2014

       

      applied following script of auto calendar

       

      [autoCalendar]:

        DECLARE FIELD DEFINITION Tagged ('$date')

      FIELDS

        Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

        Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter'),

        Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$axis', '$yearquarter'),

        Month($1) AS [Month] Tagged ('$month'),

        Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth'),

        Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber'),

        Date(Floor($1)) AS [Date] Tagged ('$date');

       

       

      DERIVE FIELDS FROM FIELDS [DateFieldName] USING [autoCalendar] ;

       

      though I can see Date.autocalendar.year and other similar fields but there is no data in created fields... How can I get week , day, year, yearMonth from the fields

       

      Need Some Urgent help.