T6: load DateCalendar resident T2; outer join (T6) load OBJECT Resident T4; //далее идет оверлоад памяти. outer join (T6) load ITEM Resident T3;
[quote][quote]Data:LOAD * Inline [DATE, QUANTITY01.12.2015, 10002.12.2015, 20003.12.2015, 50004.12.2015, 20007.12.2015, 30008.12.2015, 60009.12.2015, 500];STORE * from Data into Data.qvd (qvd);DROP Table Data;Date:LOAD Min(DATE) as MIN_DATE_N, Max(DATE) as MAX_DATE_NFROM Data.qvd (qvd);LET v_MinDate = FieldValue ('MIN_DATE_N', 1);LET v_MaxDate = FieldValue ('MAX_DATE_N', 1);FOR d = $(v_MinDate) to $(v_MaxDate) Calendar: load date($(d), 'DD.MM.YYYY') as DATE AutoGenerate(1);next dLeft Join (Calendar)LOAD DATE, QUANTITYFROM Data.qvd (qvd);STORE * from Calendar into Data.qvd (qvd);DROP Table Calendar;Data:LOAD DATE, If (IsNull(QUANTITY), 0, QUANTITY) as QUANTITYFROM Data.qvd (qvd);STORE * from Data into Data.qvd (qvd);//DROP Table Data;NoConcatenateData_01:LOAD DATE, If(QUANTITY = 0, Alt(Peek('QUANTITY'), QUANTITY), QUANTITY) as QUANTITYResident DataOrder By DATE;DROP Table Data;[/quote][/quote]