topic Simple data range question in Connectivity & Data Prep

Simple data range question

ksleiniwe — Tue, 16 Nov 2021 15:33:53 GMT

i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i generate a local autogenareted table with a date range?

in Oracle i would do someting like this:

Select:

(to_date(sysdate,'DD-MM-YYYY') - level + 1)

As day,

FROM

dual

CONNECT BY LEVEL <= (to_date(sysdate,'DD-MM-YYYY') - to_date('01-01-2014','DD-MM-YYYY') + 1);

Re: Simple data range question

edwin — Tue, 16 Nov 2021 16:18:32 GMT

if the question is to generate date field values even if you dont have those date values in a different table, you can use iterno:

//generate dates based on another date (this one is 90 days past) load date(today()-iterno()+1) as date where date(today()-iterno()+1) >= today()-90; load 1 AutoGenerate(1); //or based on number of days load date(today()-iterno()+1) as date where iterno()<=90; load 1 AutoGenerate(1);

hope that helps