Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Adding a variable in crosstable load

hello community,

i was trying to add a variable (1 AS Choice) to a crosstable loaded excel file

Directory;

CrossTable (Name, Data, 2)

LOAD Date,

etc.

// Problem starts here because of "crosstable"

1 AS Choice

FROM

(biff, embedded labels, header is 1 lines, table is Table1$);

"Choice" is simply added to "Name", Like Adam, Bernard, Charly, Choice

Is there another way, to add a variable while loading with crosstable ?

1 Solution

Accepted Solutions

Adding a variable in crosstable load

Hi,

In this type of table creation(Crosstable) try to create Resident table of that cross table.

CrossTable (Name, Data, 2)

Temp:

LOAD Date,

etc.

// Problem starts here because of "crosstable"

1 AS Choice

FROM   

(biff, embedded labels, header is 1 lines, table is Table1$);

Resident_Table:

Load

     Date,

     1 as choice,

      etc

Resident Temp;

Drop Table Temp;

Hope this helps you.

Regards,

Anand

4 Replies

Adding a variable in crosstable load

Hi,

In this type of table creation(Crosstable) try to create Resident table of that cross table.

CrossTable (Name, Data, 2)

Temp:

LOAD Date,

etc.

// Problem starts here because of "crosstable"

1 AS Choice

FROM   

(biff, embedded labels, header is 1 lines, table is Table1$);

Resident_Table:

Load

     Date,

     1 as choice,

      etc

Resident Temp;

Drop Table Temp;

Hope this helps you.

Regards,

Anand

jagannalla
Valued Contributor III

Adding a variable in crosstable load

Directory;

CrossTable (Name, Data, 2)

LOAD

1 as Choice

Date,

Date1

FROM

(biff, embedded labels, header is 1 lines, table is Table1$);

- Try this may be it helps you...

Not applicable

Adding a variable in crosstable load

@its.anandrjs your right,

i was thinking of the same solution, but im searching a way tor prevent those (load resident) steps.

If a larger amount of data is loaded like this, it will take some time.

Thanks anyway,

Alex

Not applicable

Adding a variable in crosstable load

@Anand

because of the resident load inside qlickview (which is quite fast), this uses not so much cpu time as i expected.

but it uses a lot of ram, due to the double amount of data (500T+ datasets).

in case, someone has the same problem, here is how i solved this:

this can be handled by "pumping" the data month by month, so the amount of redundant datasets is reduced.

like:

load data in "loader_table",

resident  load + variables in "temp_a",

variables loaded as %name_a,

drop "loader_table",

target table

load * (as %name)

resident temp_a

drop temp_a

load next month

and so on

problem solved. thank you

Community Browser