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;






      June 2014


      applied following script of auto calendar



        DECLARE FIELD DEFINITION Tagged ('$date')


        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.