Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
LOADVAL_x1,
VAL_y1,
(VAL_x1/VAL_y1-1) as result-E1
RESIDENT Table_A;
Table_B:
LOAD*
RESIDENT Table_A;
Qlikview combines both Tables
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.
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;
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.
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:
LOADVAL_x1,
VAL_y1,
(VAL_x1/VAL_y1-1) as result-E1
RESIDENT Table_A;
Table_B:
LOAD*
RESIDENT Table_A;
Qlikview combines both Tables