topic Re: Disable auto-labeling on wildcard table loading in QlikView

Disable auto-labeling on wildcard table loading

Anonymous — Thu, 14 Dec 2017 10:33:51 GMT

Hi all,

I have several Excel files with the exactly same structure. When I try to load them all while some fields are unqualified, it auto-numbers the label. How can I use one label instead of several?

My code is as follows,

QUALIFY *;
UNQUALIFY id;
MyList:
LOAD id, name, company FROM List*.csv;
UNQUALIFY *;

When the tables are loaded, I get MyList.name, and MyList.company. But I also got MyList-1.name, and MyList-1.company, etc.

Is there's a way I just get a single table like I didn't specify QUALIFY/UNQUALIFY at all?

Thanks a lot.

-jl

Re: Disable auto-labeling on wildcard table loading

sunny_talwar — Thu, 14 Dec 2017 16:39:05 GMT

May be do it this way

MyListTemp:

LOAD id,

name,

company

FROM List*.csv;

QUALIFY *;

UNQUALIFY id;

MyList:

LOAD *

Resident MyListTemp;

DROP Table MyListTemp;

Re: Disable auto-labeling on wildcard table loading

Anil_Babu_Samineni — Fri, 15 Dec 2017 01:44:30 GMT

Perhaps this Way?

QUALIFY *;

MyList:

LOAD id, name, company FROM List*.csv;

UNQUALIFY *;

[MyList-1]:

Load * From ....