Autogenerate date table with static data fields

chrismtb — Wed, 27 Jan 2021 10:37:05 GMT

Hi Qlikers,

I am looking for the ability to automatically generate a table in my load script.

This table will have the first date of the month for the next 12 months (starting from todays date) - this much is straight forward.

However also within this table I want at the same time to add in some static data fields which will be the same for all records.

I really want to do this as one piece of code and was wondering if it were possible (example of the output below):

the first two columns need to increment (i.e. the date and the ID) however everything else stays the same.

Is this possible?

Re: Autogenerate date table with static data fields

marcus_sommer — Wed, 27 Jan 2021 16:03:33 GMT

Maybe something like this:

load
date(addmonths(today(), recno()-1, 1) +1) as Date, 'F' & recno() as ID, '..' as Data1, '..' as Data2, '..' as Data3
autogenerate 12;

- Marcus