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

My table label gets ignored

You know, when you put a load or sql query in your load script, you precede those statements with a 'table_name:'? One of those gets ignored.

My goal is to load data from an Excel file, and then load that data again with 'resident' so I can sort it.

exampletable_temp:

LOAD id, date

FROM

[Example.xlsx]

(ooxml, embedded labels, table is Example);

SQL SELECT 1;

exampletable:

load id, date resident exampletable_temp

order by date asc;

drop table exampletable_temp;

I would think the temporary table would get filled, then the data ordered and put in exampletable, and then the temporary table deleted.

However, what happens is all data gets loaded in the temporary table, then the result of the second load also gets put in the temporary table (exampletable never gets made), and then the temporary table (with duplicate values) gets deleted. So nothing remains.

Why is that?

1 Solution

Accepted Solutions
dennisnet
Valued Contributor III

My table label gets ignored

Yes. What you are doing is create 2 identical tables. Qlikview will always combine these.

Try something like this:

exampletable_temp:

LOAD id, date

FROM

[Example.xlsx]

(ooxml, embedded labels, table is Example);

SQL SELECT 1;

exampletable:

     load id as ID_new,

     date as Date

resident exampletable_temp

order by date asc;

drop table exampletable_temp;

I think that should work.

Good luck,

Dennis.

1 Reply
dennisnet
Valued Contributor III

My table label gets ignored

Yes. What you are doing is create 2 identical tables. Qlikview will always combine these.

Try something like this:

exampletable_temp:

LOAD id, date

FROM

[Example.xlsx]

(ooxml, embedded labels, table is Example);

SQL SELECT 1;

exampletable:

     load id as ID_new,

     date as Date

resident exampletable_temp

order by date asc;

drop table exampletable_temp;

I think that should work.

Good luck,

Dennis.

Community Browser