I'm struggling to load and append the budget to the fact, since i cant use join or concatenate prefix before a cross table. can someone please help?
Budget for net comm
Budget claim incurred
You'll need to create a temporary table for your second cross table load, then do a resident load to join / concatenate to the first (take care to use NOCONCATENATE when loading the tmp table, to avoid auto concatenation to your original table).
would this be the syntax?
drop table Temp;
NB: I used the cross table wiazard to format
Hm, almost (ah, maybe you don't need to use the noconcatenate, since you want to concatenate to TableA)
CROSSTABLE (...) LOAD ... from BudgetNet;
CROSSTABLE (...) LOAD ... from BudgetClaim;
CONCATENATE (TableA) LOAD * resident TableB;
drop table TableB;
Retrieving data ...