Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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
MVP
MVP

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

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
MVP
MVP

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;