Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Not applicable

LOAD * + additional Transactions ?

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.

1 Solution

Accepted Solutions
Not applicable

LOAD * + additional Transactions ?

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

LOAD * + additional Transactions ?

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.

Not applicable

LOAD * + additional Transactions ?

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;

Not applicable

LOAD * + additional Transactions ?

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.

Not applicable

LOAD * + additional Transactions ?

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