2 Replies Latest reply: Dec 14, 2017 8:44 PM by Anil Samineni RSS

    Disable auto-labeling on wildcard table loading

    Johnny Lee

      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