How to create inline table with enumerated values?

[#1]

I want to create an inline table. It has one column 'date' which has all the days last year. How to do it?

e.g. the inline table looks like this

date

2014.01.01

2014.01.02

...

...

2014.12.31

[Miguel_Angel_Baeyens]

Hi,

You can use either the Date() function in the INLINE statement to make it look like a date, or use the "delimiter" keyword:

LOAD * INLINE [

...

] (delimiter is ' '); // for a blank space

Miguel

[Anonymous]

Hi,

Try:

Test:

Load * inline

[

date

2014.01.01

2014.01.02

...

...

2014.12.31

];

Regards

Neetha

[anbu1984 · Accepted solution]

Table:

Load Date(Date#('01/01/2014','MM/DD/YYYY')+ RowNo()) As Dt AutoGenerate(365);

[#5]

thank you! this one works well

Table:

Load Date(Date#('12/31/2013','MM/DD/YYYY')+ RowNo()) As Dt AutoGenerate(365);