topic Load budget data in QlikView

Load budget data

Anonymous — Mon, 25 Mar 2013 14:04:54 GMT

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

Re: Load budget data

swuehl — Mon, 25 Mar 2013 14:10:59 GMT

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

Re: Load budget data

Anonymous — Mon, 25 Mar 2013 14:25:30 GMT

Hi,

would this be the syntax?

Temp:

noconcatenate

crosstable

load

from

Target:

concatenate

load

resident Temp;

drop table Temp;

NB: I used the cross table wiazard to format

Re: Load budget data

swuehl — Mon, 25 Mar 2013 14:31:39 GMT

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;