Load budget data

[Anonymous]

Hi

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

date	Unit 1	unit2
1/1/13	10	40
1/2/13	20	50
1/3/13	30	60

Budget claim incurred

date	unit 1	unit2
1/1/13	20	45
1/2/13	30	45
1/3/13	40	58

[swuehl]

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).

[Anonymous]

Hi,

would this be the syntax?

Temp:

noconcatenate

crosstable

load

a,

b,

from

Target:

concatenate

load

a

b

resident Temp;

drop table Temp;

NB: I used the cross table wiazard to format

[swuehl]

Hm, almost (ah, maybe you don't need to use the noconcatenate, since you want to concatenate to TableA)

TableA:

CROSSTABLE (...) LOAD ... from BudgetNet;

TableB:

CROSSTABLE (...) LOAD ... from BudgetClaim;

TEMP:

CONCATENATE (TableA) LOAD * resident TableB;

drop table TableB;