Such task could be solved by deriving at first a Von-Bis range from the date and then the range is resolved to dedicated dates, for example with an approach like:
load *, date(Von + iterno() - 1) as FinalDate while Von + iterno() - 1 <= Bis; load *, Datum as Von, if(Artikel <> previous(Artikel), today(), date(previous(Datum) - 1) as Bis resident Temp order by Artikel, Datum desc;
