Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
johnnykhlee
New Contributor

Disable auto-labeling on wildcard table loading

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

1 Solution

Accepted Solutions

Re: Disable auto-labeling on wildcard table loading

May be do it this way

MyListTemp:

LOAD id,

    name,

    company

FROM List*.csv;

QUALIFY *;

UNQUALIFY id;

MyList:

LOAD *

Resident MyListTemp;

DROP Table MyListTemp;

2 Replies

Re: Disable auto-labeling on wildcard table loading

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

Perhaps this Way?

QUALIFY *; 

MyList: 

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

UNQUALIFY *;


[MyList-1]:

Load * From ....

Life is so rich, and we need to respect to the life !!!
Community Browser