I prepared a demo for you...
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='YYYY-MM-DD';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='de-DE';
SET CreateSearchIndexOnReload=1;
for i= MakeDate(2018,1,1) to MakeDate(2018,3,31)
Master:
LOAD Date($(i)) as Datefield AutoGenerate 1;
next
Facts:
LOAD *,Datefield&'|'&Operation as TEMPKEY;
LOAD *INLINE [
Datefield, Operation, Amount
2018-01-15, Sales, 500
2018-02-15, Sales, 1000
2018-03-15, Purchases, -400
];
//fill up Sales
concatenate(Facts)
LOAD
Datefield, 0 as Amount, 'Sales' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Sales');
//fill up Purchases
concatenate(Facts)
LOAD
Datefield, 0 as Amount, 'Purchases' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Purchases');
drop field TEMPKEY;
