I have one table name DAT . On every monday and thursday data is uploaded in it but with same count [ 36k rows were added on every monday and thursday]. it consist 4 fields
for ex 16-6-2021 thursday
coulmn 1 date 2 origin_area 3 dest_area 4 rates KEY (created by me)
data 16-6-2021 MU_FT GT_OI 3.4 (16-6-2021 MU_FT- GT_OI)
It Is basically the rates that were added every time on Monday and Thursday with fixed no of rows.
but I have no data for like date 17,18,19 as there is no such date present .
So basically I need dates and data for 17 18 19 which should be same for 16 th date . then on monday on 20th new rates will come So again I want those data to be replicate for 21 22?
MinMaxTable: Load Max(date) as Maxdate, Min(date) as Mindate Resident [DAT];
Let vMax= Peek('Maxdate',0,'MinMaxTable'); Let vMin= Peek('Mindate',0,'MinMaxTable');
Drop Table MinMaxTable;
Calender: Load date($(vMin) + RowNo()-1) as X AutoGenerate $(vMax) - $(vMin)+1;
