topic Re: How to create inline table with enumerated values? in QlikView

How to create inline table with enumerated values?

Thu, 26 Feb 2015 09:39:16 GMT

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

Re: How to create inline table with enumerated values?

Miguel_Angel_Baeyens — Thu, 26 Feb 2015 11:33:15 GMT

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

Re: How to create inline table with enumerated values?

Anonymous — Thu, 26 Feb 2015 11:42:38 GMT

Hi,

Try:

Test:

Load * inline

[

date

2014.01.01

2014.01.02

...

...

2014.12.31

];

Regards

Neetha

Re: How to create inline table with enumerated values?

anbu1984 — Thu, 26 Feb 2015 11:49:02 GMT

Table:

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

Re: How to create inline table with enumerated values?

Fri, 27 Feb 2015 00:34:28 GMT

thank you! this one works well

Table:

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