Concatenation of tables and Auto Calendar Script

shwetagupta — Fri, 03 Jun 2016 16:39:32 GMT

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.

Re: Concatenation of tables and Auto Calendar Script

Gysbert_Wassenaar — Sat, 04 Jun 2016 14:06:06 GMT

Make sure your date field actually contains date values, not text values that only look like dates. Use the date# function if necessary to convert text values to date values. Perhaps this blog post helps: Why don’t my dates work?

Re: Concatenation of tables and Auto Calendar Script

shwetagupta — Sun, 05 Jun 2016 16:45:17 GMT

Hi Gysbert

Thanks a lot, though my excel sheet field was in Date format but I used date# it solved my problem.

Thanks

topic Re: Concatenation of tables and Auto Calendar Script in App Development

Concatenation of tables and Auto Calendar Script

Re: Concatenation of tables and Auto Calendar Script

Re: Concatenation of tables and Auto Calendar Script