Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

adoteykwame
Not applicable

Load budget data

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/131040
1/2/132050
1/3/133060

Budget claim incurred

dateunit 1
unit2
1/1/132045
1/2/133045
1/3/134058
3 Replies
swuehl
Not applicable

Re: Load budget data

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

adoteykwame
Not applicable

Re: Load budget data

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
Not applicable

Re: Load budget data

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;