topic LOAD * + additional Transactions ? in QlikView

LOAD * + additional Transactions ?

Tue, 15 Nov 2011 09:45:52 GMT

Good morning/afternoón (depends on where you are)

is it possible, to shorten a load statement with * (i know, this is, but here comes the fun part) AND use ADDITIONAL formulas etc. during load ?

i tried this, but its not working:

Table_B:
LOAD
*

(VAL_x1/VAL_y1-1) as result-E1,
(VAL_x2/VAL_y2-1) as result-E2,

(VAL_x2/VAL_y2-1) as result-E3

RESIDENT Table_A;

the goal was, to make the load statement more readable and saving space in the code by not having to write down all the other (old) fields.

LOAD * + additional Transactions ?

Tue, 15 Nov 2011 10:09:33 GMT

as you are applying a formula in the load then make sure that the values used i.e VAL_x1,VAL_x2,VAL_y2 and VAL_y1 must be loaded before appling the formula and must be in the table Table_A.

check it.

LOAD * + additional Transactions ?

Tue, 15 Nov 2011 10:17:31 GMT

I thought, the * would load all the data, then the formula would produce the results for "result-E1"

im not shure if i did understand you right.

this wont work:

Table_B:
LOAD
*

VAL_x1,

VAL_y1,

(VAL_x1/VAL_y1-1) as result-E1

RESIDENT Table_A;

LOAD * + additional Transactions ?

Tue, 15 Nov 2011 11:41:04 GMT

check it that the variables:

VAL_x1,VAL_y1

is in Table_A or not.

As Table_A is resident by you so the variables used by you in the formula must be present in Table_A.

2. both the variables are of same data type i.e integers.

LOAD * + additional Transactions ?

Tue, 15 Nov 2011 14:09:09 GMT

Table_A exists,

contains VAL_x1,VAL_y1

and with a normal LOAD, when all necessary collumns are loaded, it works fine.

There are 30 collumns, loaded from a resident table.

But, i tried to replace most of them with an *. Only the additional colloumns and their needed attributes should be there.

SOLUTION: Two seperate LOAD Statements

Table_B:
LOAD
     VAL_x1,
     VAL_y1,
     (VAL_x1/VAL_y1-1) as result-E1
RESIDENT Table_A;

Table_B:
LOAD
*
RESIDENT Table_A;

Qlikview combines both Tables